Aggregating Missing Values During Calculation

By default, during full database calculations, Essbase does not aggregate missing (#MISSING) values. When data is not loaded at parent levels, aggregating missing values may improve calculation performance. For databases for which you have Database Manager permissions, you can choose whether to aggregate missing values. Your decision becomes effective immediately after you click Apply.

Note:

This functionality does not apply to aggregate storage databases.

To elect to aggregate missing values during database calculations:

From Enterprise View or a custom view, select a database.
Right-click, and select Edit, and then Properties.
In the Database Properties window, select the General tab.
Expand the Calculation node.
Select Aggregate missing values.
Click Apply.

Related Information

Database Properties Window—General Tab
“Consolidating #MISSING Values” in the Oracle Essbase Database Administrator's Guide
Calculating Block Storage Databases

Related Commands

alter database (MaxL) in the Oracle Essbase Technical Reference
setdbstate (ESSCMD) in the Oracle Essbase Technical Reference
setdbstateitem (ESSCMD) in the Oracle Essbase Technical Reference