SET AGGMISSG

Specifies whether Essbase consolidates #MISSING values in the database.

The default behavior of SET AGGMISSG is determined by the global setting for the database, as described in the Oracle Essbase Database Administrator's Guide.

Syntax

SET AGGMISSG ON | OFF ;

Notes

SET AGGMISSG commands apply to calculating sparse dimensions.

Example

SET AGGMISSG OFF;
CALC ALL;
CALC PERCENTS;