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...