Level a layer in a hierarchical tree structure that

  • No School
  • AA 1
  • gomez94
  • 50

This preview shows page 24 - 37 out of 50 pages.

Level ―A layer in a hierarchical tree structure that defines database member relationships. Levels are ordered from the bottom dimension member (Lev0) up to the parent members.‖ Alternate Hierarchy ―A hierarchy of shared members. An alternate hierarchy allows the same data to be seen from different points of view.‖ Examples Functional Org / Geographic Org. Child, Parent, Sibling, Ancestors, Descendants
Image of page 24
Generations & Levels Please note that it is possible to have Level 0 members at any Generation of a hierarchy. In this case notice that PeriodUnalloc is Generation 2, but Level 0, whereas it’s siblings are Generation 2, and level 1
Image of page 25