GRIDSUPPRESSINVALID

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 databases.

Syntax

GRIDSUPPRESSINVALID [appname [dbname]] TRUE | FALSE

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

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

• TRUE—Enables suppressing invalid attribute combinations on the grid. This is the default value.

• FALSE—Invalid attribute combinations are not suppress on the grid.

Example

GRIDSUPPRESSINVALID Sample Basic TRUE

Suppresses #invalid values in the Sample.Basic database.

See Also

Suppressing Invalid Attribute Combinations in the Grid.