Working with Dimension Hierarchies

You can use dimension hierarchies to define dimension member relationships for data entry and calculations.

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.