MAX_REQUEST_GRID

MAX_REQUEST_GRID_SIZE

Sometimes you need to limit the size of Essbase query grids flowing from a block storage (BSO) replicated partition source cube to an aggregate storage (ASO) replicated partition target cube.

You can use the Essbase configuration setting MAX_REQUEST_GRID_SIZE to limit the request grid size (the number of cells requested from a source cube by a user on an ASO target cube). Limiting the size of the request grid, which can be millions of cells, improves 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.