SET AGGMISSG

The SET AGGMISSG command specifies whether Hyperion Essbase aggregates #MISSING values in the database.

SET AGGMISSG ON | OFF ;

SET AGGMISSG specifies whether Hyperion Essbase aggregates #MISSING values in the database. The default behavior of SET AGGMISSG is determined by the global setting for the database, as described in the Database Administrator's Guide.

Notes

SET AGGMISSG commands apply to calculating sparse dimensions and not to aggregating.

Example

SET AGGMISSG OFF;
CALC ALL;
CALC PERCENTS;