Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mrrana78
Starting Member
2 Posts |
 Posted - 2008-08-31 : 20:40:17
|
| HiI 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 columnsAccount, Account Desc, HierchyAAALevel1,HierchyAAALevel2,HierchyAAALevel3,HierchyBBBLevel1 , HierchyBBBLevel2,HierchyBBBLevel3That data look like this123,Building07/08 ,Building07/08,Building,Cap07 ,NULL,NULL,NULL122,Land07/08 , Land07/08 ,Land07,Cap07 ,Land07/08,Land08,Cap08144,Water08 , Null , Null , Null ,Water08,Water,Cap08So 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 3I 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 ableany help would be much appreciatedRaheel |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-02 : 10:13:29
|
| i think you've something like ISEMPTY which can be used to remove the NULL ones. Refer to booksonline for more details. |
 |
|
|
|
|
|
|
|
Filter Hierarchy