SQL Server Performance

Ragged Hierarchy ….

Discussion in 'SQL Server 2005 Analysis Services' started by mrrana78, May 8, 2008.

  1. mrrana78 New Member

    I want to hide the level/member(s) if it’s missing i.e. NULL …so the Last non-empty leaf can appear when I browse the Cube with this particular dimension. For that what I have found so far is to use HideMemberIf property of the Hierarchy i.e OnlyChildWithNoName . But that seen not to be working … Am I missing to set any property…..
    Example
    ID EType1 EType_2 EType3 Number Name
    1 1 NULL NULL 111 ABC
    2 2 1 4 112 CDT
    3 2 1 NULL 121 HUY
    4 3 NULL 8 231 YYY
    5 NULL 5 NULL 22 777
    6 NULL NULL 2 876 rrr
    Any Advise
    Regards
    Raheel
  2. satya Moderator

Share This Page