Specifies the maximum size of the request grid. The request grid is the number of cells requested from the target (an aggregate storage database) and sent to the data source. Limiting the size of the request grid, which can be millions of cells, ensures a reasonable response time.
If you find that you must set a small request grid size, you should look into improving the design of the application.
MAX_REQUEST_GRID_SIZE [appname [dbname]] n
appname—Optional. Specifies the application for which the request grid size 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 the request grid size is to be set.
If you specify a value for dbname but do not specify a value for appname, your specification is ignored, and logging diagnostic messages is enabled for all applications and databases on Essbase Server.
n—Specifies the size of the request grid to be returned from the data source.
The default value is 10 million (10000000) cells.
You must restart Essbase Server to initialize any change to the configuration file.
MAX_REQUEST_GRID_SIZE ASOSamp 5000000
Limits the request grid to 5 million cells for all databases associated with the ASOSamp application.
MAX_RESPONSE_GRID_SIZE configuration setting
ENABLE_DIAG_TRANSPARENT_PARTITION configuration setting