Specify Balanced Hierarchies

Oracle Essbase Provider does not determine if a hierarchy is balanced or unbalanced. It considers all hierarchies as being unbalanced by default.

In a balanced hierarchy, each path descends to the same depth while the branches in an unbalanced hierarchy descend to different levels.

Procedure

  1. In the Hyperion Solutions Essbase Administration Services tool, create a special User Defined Attribute (UDA) named COGNOS_HIERARCHY_BALANCED in the outline of the Essbase database. The UDA is created for the root member of the corresponding dimension containing a balanced hierarchy.
  2. Set the attribute to 1.
Parent topic: Oracle Essbase Data Source