Working with Dimension Hierarchies

Dimension hierarchies define structural and mathematical relationships, and consolidations between members in the database. Relationships are represented graphically in a collapsible hierarchy diagram. Upper-level dimension members are called parent members, and a member immediately below a parent member is referred to as its child. All members below a parent are referred to as descendants. The bottom-level hierarchy members are called base-level members.

Data is entered into base-level members of dimensions and not into parent members. Values for parent-level members are aggregated from the children of the parent-level members. In some cases, data for base-level members is calculated.

Note:

As a best practice, a limit of 20 levels of hierarchy depth is recommended.