Analysis Services 2005 Parent Child Dimensio Question

• Preston M. Price

  Old Hand

  Points: 301

  More actions

  June 1, 2006 at 3:37 pm

  #366354

  I have a simple parent child dimension set up where the root level records have a ParentID of .

  When I browse the hierarchy the root level appear correctly, but when I drill into one of the levels of the hierarchy, the root level element is duplicated at the next level even though there is no such relationship in the dimension.

  Here is a simplified example of records in the dimension:

  ID Name ParentID

  1 Root1

  2 Level1 1

  3 Root2

  4 Level2 3

  The hierarchy looks like this when I browse:

  All

  - Root1

  - Root1

  - Level1

  - Level1

  - Root2

  - Root2

  - Level2

  - Level2

  How can I keep the levels of my hierarchy from repeating?

• g4rc

  Newbie

  Points: 5

  More actions

  June 2, 2006 at 3:29 am

  #641368

  If you go to the properties of the 'parent key' attribute there is a attribute called 'MembersWithData'

  Set this to the value 'NonLeafDataHidden'

  Then process the dimension, and it must works

   

   

  Greetz