Hyperion Essbase Dimension Terminology
Posted by Dylan Wan on June 20, 2008
I found the the language used in Hyperion Essbase documentation is very useful for describing the dimension hierarchy. To communicate effectively, sometime we need precise teams to describe things. The terms defined in the Hyperion Essbase documentation helps.
Member: A node within a hierarchy.
Root: The root is the top member in a hierarchy.
Parent: A parent is a member that has another member below it.
Child: A child is a member that has a parent above it.
Sibling: Siblings are child members of the same immediate parent, at the same generation.
Descendant: Descendants are all members in branches below a parent.
Ancestor: Ancestors are members in branches above a member.
Leaf: Leaf members have no children.
Generation: A generation refers to a level within a dimension. A root branch of the tree is generation 1. Generation numbers increase as you count from the root toward the leaf member.
Level: Level also refers to a branch within a dimension; levels reverse the numerical ordering used for generations. Levels count up from the leaf member toward the root. The root level number varies depending on the depth of the branch. All leaf members are level 0. The parents of leaf members are level 1. The level number of a member varies depending on the branch.
Many are similar to the terms used in PeopleSoft Tree Manager, but Hyperion Essbase separates the Generation Number from the Level Number. The term Descendant and Ancestor are useful.
PeopleSoft Tree Manager, on the other hand, have its special notions of Summer Tree, Winter Tree, and Spring Tree.
1. Hyperion Essbase, Database Administrator’s Guide – Understanding Multidimensional Databases.