Hi
I am sort of
stuck with this issue ...I want to be able to Filter Hierarchy to
exclude member that are null... Basically what I got is what we called
leveled table ....that maintain alternative hierarchies..... Dimension
called accounts ..it has three hierarchies .... the underlying table
has following columns
Account, Account Desc,
HierchyAAALevel1,HierchyAAALevel2,HierchyAAALevel3,
HierchyBBBLevel1 , HierchyBBBLevel2,HierchyBBBLevel3
That data look like this
123, Building07/08, Building07/08, Building , Cap07 , NULL, NULL, NULL
122 Land07/08 , Land07/08 , Land07 Cap07 ,Land07/08 , Land08 , Cap08
144 Water08, Null , Null , Null, Water08, Water, Cap08
So when I make Hierarchy named "HierarchyAAA" using column HierchyAAALevel3,HierchyAAALevel2,HierchyAAALevel1 ( Top to bottom) . dimension processes fine , when I browse I have CAP07 and NULL at level 3
I
want the hierarchy to only show Non Null members whenever this
hierarchy is used , with any measure. I am not even sure if its do able
any help would be much appreciated
Raheel