SQL Server Performance

Filtering Hierarchy Members

Discussion in 'SQL Server 2005 Analysis Services' started by mrrana78, Aug 31, 2008.

  1. mrrana78 New Member

    Hi
    I am sort ofstuck with this issue ...I want to be able to Filter Hierarchy toexclude member that are null... Basically what I got is what we calledleveled table ....that maintain alternative hierarchies..... Dimensioncalled accounts ..it has three hierarchies .... the underlying tablehas 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
    Iwant the hierarchy to only show Non Null members whenever thishierarchy is used , with any measure. I am not even sure if its do able

    any help would be much appreciated

    Raheel
  2. mrrana78 New Member

    I had hierarchy levels setup incorrectly , so I changed that and Than changed the HidememberIf property to " NoName " ... and that eliminated all Null data

Share This Page