Variable Level Hierarchies

[egrosso]

Hi All,
I want to drill through a hierarchy that has n level, the tree is unbalanced and it is physically represented with a flat table with the maximum possible levels.
How can I drill directly to the leaf without having to pass through all the NULL levels when a branch stops before the last level ?
Any ideas to work with a drill map or something similar ?
Thank you.

Edward

 

[FLB]

You can create a new drill hierarchy and create a relationship between the level you want to be able to drill from.

MicroStrategy does not like NULL for IDs.... You might want to replace those by a unique ID anyway.

2 cents,
FLB