MAX_REQUEST_GRID

MAX_REQUEST_GRID_SIZE

This Essbase configuration setting 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.

Syntax

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.

The maximum value is limited by the unsigned int value of 4294967295.

You must restart Essbase Server to initialize any change to the configuration file.

Example

MAX_REQUEST_GRID_SIZE ASOSamp 5000000

Limits the request grid to 5 million cells for all databases associated with the ASOSamp application.