When set to ON, improves performance when transparent partitions are queried.
GRIDEXPANSION ON | OFF
The default value is ON.
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.
If client queries receive incorrect results, set FORCEGRIDEXPANSION to ON. (If GRIDEXPANSION is set to OFF, the FORCEGRIDEXPANSION setting is ignored.)