Specifies whether optimized grid processing, which cuts the input grid into symmetric grids to create fewer symmetric queries, is enabled for spreadsheet operations.
SSOPTIMIZEDGRIDPROCESSING [appname [dbname]] TRUE | FALSE
appname—Optional. Specifies the application for which optimized grid processing is to be set.
If you specify a value for appname and do not specify a value for dbname, the setting applies to all databases in the specified application.
To enable the setting for a specific database, you must specify an application and database.
If you do not specify an application, you cannot specify a database, and the setting applies to all applications and databases on Essbase Server.
dbname—Optional. Specifies the database, in the application specified by appname, for which optimized grid processing is to be set.
If you specify a value for dbname but do not specify a value for appname, your specification is ignored.
TRUE—Enables optimized grid processing for spreadsheet operations.
FALSE—Disables optimized grid processing for spreadsheet operations.
The default value is FALSE.
For changes to the configuration file to take effect, you must restart Essbase Server.
SSOPTIMIZEDGRIDPROCESSING TRUE
Enables optimized grid processing for spreadsheet operations on all applications and databases on Essbase Server.