Selecting Hierarchy Storage Settings

  To specify the storage option for hierarchies:

1. Access the dimension properties tabs of the Essbase Model Properties dialog box using the procedure in Accessing the Dimension Properties Tabs.

2. Select the Outline Build tab.

3. In the Hierarchy settings group, select an option:

   • Stored at dimension level—Sets the dimension as a stored hierarchy. This is the default.

   • Dynamic at dimension level—Sets the dimension as a dynamic hierarchy. When selected, the Create as compression dimension check box is enabled.

     Optional:

     Create as compression dimension check box—Optimizes an aggregate storage database.

     When selected, data is grouped in the dimension as (key, mulitple values).

     If this check box is not selected, data is stored as (key, single value), (key, single value).

     Tip:	Oracle recommends optimizing aggregate storage databases by compressing the accounts dimension.

     For further information on the compression dimension, see “Understanding the Compression Dimension for Aggregate Storage Databases” in the Oracle Essbase Database Administrator's Guide.

   • Multiple-hierarchy enabled—Uses both stored and dynamic hierarchies in the dimension.

     Note:

     Because hierarchies determine how data is consolidated and navigated, you should review any aggregate storage settings you may have for generation 2 members by clicking the link to the Member Info tab.

4. Click Apply.

   Note:

   To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.