Essbase - Member Relationships
About
Essbase uses terms to describe the roles and relationships of the members in a database outline.
| Hierarchical terms description | |
|---|---|
| Essbase - Generation | Generation refers to a consolidation level within a dimension. |
| Essbase - Level | Level also refers to a branch within a dimension; levels reverse the numerical ordering used for generations. |
| roots | The root is the top member in a branch. |
| leaves | Leaf members have no children. |
| Family history terms description | |
| Essbase Parent | A parent is a member that has a branch below it. |
| Essbase 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. |
| descendants | Descendants are members in branches below a parent. |
| ancestors | Ancestors are members in branches above a member. |
To ease report maintenance, you can assign a name to a generation or level and then use the name as a shorthand for all members in that generation or level. Because changes to an outline are automatically reflected in a report, when you use generation and level names, you do not need to change the report if a member name is changed or deleted from the database outline.
