Winner of this week is ascheevel!
Question #6:
We are done with feeders, well done! Now new set of questions.
There is "Employee" cube with employees list, their job types and salaries (from 24Retail sample). Picklist for Job Type uses subset with alias enabled (element names are different). I've created a new "Employee analysis" cube with extra "JobType" dimension.
Write a rule (without feeder. Spoiler: this will be the next question) to transfer data from "Employee" to "Employee analysis" cube.
Dimension order in "Employee" cube:
- Organization
- EmployeeList
- Year
- Version
- Employee