Hi,
I am back to SSAS after a really long time. Got to generate and process a cube today when noticed (refer screenshot please) that in my Dimension Hierarchy, If I have say 2 levels with values as below
1000
1001
1002
2000
2001
2002
But it appears instead as below WHEN USING THIS HIERARCHY AS FILTER, either in Excel Pivot or even browsing Cube. When using this Hierarchy in Rows its fine.
1000
1000
1001
1002
2000
2000
2001
2002
Note that parent level 1000 and 2000 also appears in second level appearing as first member. Is this happening because the hierarchy is being flattened ?
How can we get rid of for this ?
As mentioned earlier this behavior ONLY happens when using this Hierarchy as a FILTER, either in Excel or browsing Cube through SSMS.