5 Replies Latest reply: Jan 31, 2013 7:55 AM by Christian Berg RSS

    Dimension Hierarchy

    Robert Angel

      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,