Selecting an Aggregate Storage Option

If you are using aggregate storage, you can select an option for storing the data values. See Aggregate Storage Guidelines.

  To select an aggregate storage option:

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

  2. Select the Info tab.

  3. Locate the ASO Storage Options group.

  4. Select the ASO Storage Options:

    • Store—Data values are stored with the member. This is the default setting for new members.

    • Dynamic—Data values associated with the member are not calculated until requested by a user. After the calculation is completed, the data values are not stored and are discarded.

    • External source—In the drop-down list, select the column in the database that contains the aggregate storage option.

      Note:

      For the member codes to use in external data sources, see “Using the Data Source to Work With Member Properties” and “Data Source Differences for Aggregate Storage Dimension Builds” in the Oracle Essbase Database Administrator's Guide.

  5. 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.