June 11, 2014 at 10:11 pm
How can I link two separate dimension hierarchies (driven from two base dimension tables) to the same attribute in the Cube?
When I try this, only the common hierarchy levels between two dimensions show up under Browse. Other levels disappear. Details are:
a) One SSAS 2012 Cube: Expense Daily Snapshot. Each fact row has CostCentreSK attribute.
b) Two dimensions (with natural hierarchies) based on two separate DB tables. CostCentreSK is the key in both. (I know it sounds strange, but there is a good reason for this. Be happy to share details.)
After processing when I browse the cube, only the common levels between the two hierarchies show up.
Expectation was that the individual hierarchies will show each of their levels. Please help.
June 12, 2014 at 2:57 am
When you are browsing the cube I assume that you're doing so with some sort of measure? If so then by default (in the VS browser) then the non intersecting levels of both hierarchies will not appear (since you are performing a NON EMPTY crossjoin by default). You can right click on the results pane and choose "Include empty cells" and the picture should become clearer.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply