Multiple Hierarchies

Last Post 18 Aug 2005 07:12 AM by Shill_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

18 Aug 2005 07:12 AM
In the cubes we use we have a shared products dimension that consists of the following levels:
Major Group
- 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.
Major Group
- Product Description


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.

Acceptable Use Policy