GRIDEXPANSION

This Essbase configuration setting, when set to ON, improves performance when transparent partitions are queried.

Syntax

GRIDEXPANSION [appname [dbname]] ON | OFF

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.
ON—This is the default value. Enables grid expansion.
OFF— Suppresses grid expansion.

Description

GRIDEXPANSION improves performance of some queries. If all of the following conditions are met, however, client queries may receive incorrect results (such as most data values displaying as #MISSING, whether or not cells contain data):

The client queries the target database of a transparent partition.
The client query requests values from a dynamically calculated block.
Cells requested from the dynamically calculated block reference dense, dynamically calculated members.
Dense, dynamically calculated members depend on values from one or more source databases.