In the cubes we use we have a shared products dimension that consists of the following levels:
- Minor Group
-- Product Description
--- Product Code (not really used)
I would like to be able to maintain this functionality but add the ability to view this data differently e.g.
- Product Description
To confound things further there is also the possibility of including a manufacturer. A manufacturer can sell products crossing major product groups and/or minor groups. Another 3 permutations.
How can I implement this without creating a significant performance hit. I tried multiple hierarchies (at least what I thought were multiple hierarchies) but on testing it the cubes were processing when I arrived in work some 4½ after the task started.