I'm creating a hierarchical dimension based on a parent child from a table, however a member doesn't have a unique id defined, it's uniqueness comes from the path it would create.
eg trying to produce this heirarchy:
1
/ 2 3
/ \ 4 5 4
Coming from this table:
Parent Child
2 4
2 5
3 4
1 2
1 3
Any help would be greatly appreciated, this is for building a cube.
Basically, is there a way of getting around the problem of merging non-unique data.
a - b - c -d 1
a - b - c -d 3
a - b - c -d 5
instead of
a - b - c -d 9
I am just a beginner at cube building but it is fairly urgent. Regards
Matt
eg trying to produce this heirarchy:
1
/ 2 3
/ \ 4 5 4
Coming from this table:
Parent Child
2 4
2 5
3 4
1 2
1 3
Any help would be greatly appreciated, this is for building a cube.
Basically, is there a way of getting around the problem of merging non-unique data.
a - b - c -d 1
a - b - c -d 3
a - b - c -d 5
instead of
a - b - c -d 9
I am just a beginner at cube building but it is fairly urgent. Regards
Matt