This discussion is archived
5 Replies Latest reply: Jan 31, 2013 5:55 AM by Christian Berg RSS

Dimension Hierarchy

Robert Angel Pro
Currently Being Moderated

I have a dimension with; -

Base Member, Level 1 Parent, Level 2 Parent, Level 3 Parent - etc- to Level 20 Parent

I want to build a dimension hierarchy thus; -
    ¬ Level 1
                ¬Level 2
                            ¬Level 3
                                               ¬Level 20
                                                             ¬Detail Level

My question is, given that ANY level beyond Level 1 may be null, what do I set to short cut the drill path to go straight to Detail Level when Level x is null?

thanks for your input,



  • Correct Answers - 10 points
  • Helpful Answers - 5 points