We are having problems with the dimension attributes in lower level hierarchies not grouping under 1 single level.
Here is the hierarchy:
The top 3 levels are grouping correctly without duplicate rows and they don't have compoud keys. The lowest 3 levels are not grouped correctly and they have compounds keys because the attributes are not unique by themself.
The result of the hierarchy looks like this:
VP Academic Affairs
Business School of Management
International Business School
Course Number 123
View Complete Post