In aggregate storage databases, within dimensions you can create two types of hierarchies:
Stored
Dynamic
Each hierarchy type provides unique advantages and restrictions. One dimension can contain both hierarchy types. To use both hierarchy types within one dimension, you must enable multiple hierarchies for the dimension. The generation 1 members of dimensions that are enabled for multiple hierarchies are tagged label-only.
The dimension tagged as accounts is automatically considered a dynamic hierarchy. You cannot specify the accounts dimension as a stored hierarchy.
For information about restrictions imposed by dynamic hierarchies and stored hierarchies, see the Oracle Essbase Database Administrator's Guide.
Note: | During dimension builds, you can use dimension properties to designate hierarchies as dynamic or stored. |
To enable multiple hierarchies for dimensions:
The Outline tab is displayed.
Right-click a dimension, and select Edit member properties.
In the Member Properties dialog box, select the Information tab.
In Hierarchy, select Hierarchies Enabled.
Click OK.
To tag dimensions or generation 2 members as dynamic or stored hierarchies:
The Outline tab is displayed.
Right-click a dimension or member, and select Edit member properties.
In the Member Properties dialog box, select the Information tab.
In Hierarchy, select Dynamic or Stored.
If multiple hierarchies are enabled for the dimension, you can repeat steps 1–4 for all generation 2 members of the dimension, thus selecting a hierarchy type for each member.
Click OK.
“Hierarchies” in the Oracle Essbase Database Administrator's Guide