Parent-Child Dimension Help

[zdnh]

Hi All,

I am trying to build a Parent-Child Dimension. In addition to Parent-Child heirarchy, there is additional LeveL heirarchy in my table:

example --
ChildId, ChildName, ParentId, LevelName
1, 'SA', null, 'Top'
2, 'A', 1, 'Level2'
3, 'B', 3, 'Level3'
4, 'XX', null, 'Level2'

Records in the table are recursive. In the above example, if I bulid a parent-child dimension based on ParentID and ChildID, records 1 and 4 show at the same level. How can I incorporate LevelName in my hierarchy?

Appreciate any help that I can get.

 

[MDXer]

use compund keys where your member key is ChildID+LevelName and your ParentKey is ParentID+LevelName. I haven't built any Parent Child Dims in SSAS2005 but I do know that you can build the Compound key Directly in the dimension structure on other dimension types.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck