Setting Hierarchy Type Property

The ‘Hierarchy Type’ property applies only to Aggregate Storage Databases in Essbase.

To be able to use other consolidation type symbols (other than ADDITION and IGNORE) the hierarchy type should be set to ‘DYNAMIC.’

Note:

If a dimension member has a formula, the hierarchy type must be set to ‘DYNAMIC.’

To set the Hierarchy Type:

1. From Oracle Hyperion Enterprise Performance Management Workspace, select Navigate, then Administer, and then Dimension Library.
2. Under the application, select some dimension (except Alias, Attribute, UDA).
3. In the Property Grid, select the appropriate Hierarchy Type property:

   • Select Stored for any dimension whose dimension members use the following consolidation symbols:

     • + ADDITION

     • ~ IGNORE (only underneath LABEL ONLY members.)

   • Select Dynamic for any dimension whose dimension members needs to use all supported consolidation symbols, or have a formula.

4. Redeploy the application to Oracle Hyperion Profitability and Cost Management, and then Oracle Essbase.