Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Variable Level Hierarchies

Status
Not open for further replies.

egrosso

Programmer
Jun 22, 2002
3
AU
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top