SET AGGMISSG

Specifies whether Analytic Services consolidates #MISSING values in the database.

Syntax

SET AGGMISSG ON | OFF ;

Description

SET AGGMISSG specifies whether Analytic Services 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 Database Administrator's Guide.

Notes

SET AGGMISSG commands apply to calculating sparse dimensions.

Example

SET AGGMISSG OFF;
CALC ALL;
CALC PERCENTS;

See Also

Set Commands

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com