Good day everyone


I am a bit new at building cubes and dimensions within MSAS. I went through
the tutorial on the MSAS screen and worked through the excercises.

However, I am now faced with a callenge.


I have a table in SQL with two columns in it

ColumnA Column B
1 2
1 3
2 A
2 B
3 4
4 5
4 6
4 7

In the above structure 2 is a child of 1 but 2 has children of its own but s
appears in both columsn. The point being that I understand parent child
relationship but in the above case you will have different levels in the same
dimension and if I use the normal cube building techniques that I saw in the
tutorial I will have levels with empy members etc. How can I build a
Dimension that looks something like ths

1 2 A
B
3 4 5
6
7
8 9

10

etc.

Thanks