Changing Consolidation for Performance

To consolidate, enable the setting for consolidating #MISSING values by using one of the methods described above. The degree of performance improvement you achieve depends on the ratio between upper-level blocks and input blocks in the database.

  To change how Essbase consolidates #MISSING values, use a tool:

Tool

Topic

Location

Administration Services

Aggregating Missing Values During Calculation

Oracle Essbase Administration Services Online Help

Calculation script

SET AGGMISSG

Oracle Essbase Technical Reference

MaxL

alter database

Oracle Essbase Technical Reference

ESSCMD

SETDBSTATEITEM

Oracle Essbase Technical Reference

Note:

If you enable the setting for consolidating #MISSING values, the cell calculation order within a data block changes. See Cell Calculation Order.

When the setting for consolidating #MISSING values is disabled, note that the performance overhead is particularly high in the following situations:

In these situations, the performance overhead is 10%–30%. If calculation performance is critical, you may want to reconsider the database configuration or how you load data.

For a information on how Essbase calculates #MISSING values, see Consolidating #MISSING Values.