GRIDSUPPRESSINVALID

This Essbase configuration setting sets whether invalid attribute combinations, which are represented on the grid by #invalid, are suppressed in Smart View.

An invalid attribute combination is the result of an intersection of a dimension member for which an attribute is not assigned or, if an attribute is assigned to the member, the attribute combination is not within the scope of the grid query or the assigned attribute is incorrect. Invalid attribute combinations are suppressed when the row contains all #invalid values. Valid combinations with #MISSING values are not suppressed.

This configuration setting applies to block storage and aggregate storage cubes.

Syntax

GRIDSUPPRESSINVALID [appname [dbname]] TRUE | FALSE

• appname—Optional. If you specify an application name, the setting applies to all cubes within the named application. If you do not specify an application name, the setting applies to all applications and cubes on the Essbase Server.

• dbname—Optional. If you specify a database (cube) name and an application name, the setting applies only to the named cube. If you do not also specify an application name, the setting applies to all applications and cubes on the Essbase Server.

• TRUE—Enables suppressing invalid attribute combinations on the grid.

• FALSE—Invalid attribute combinations are not suppressed on the grid. This is the default value.

Example

GRIDSUPPRESSINVALID Sample Basic TRUE

Suppresses #invalid values in the Sample.Basic cube.

See Also

Suppressing Invalid Attribute Combinations in the Grid.