MAX_RESPONSE_GRID

MAX_RESPONSE_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 MAX_REQUEST_GRID_SIZE to limit the total request grid size.

The MAX_RESPONSE_GRID_SIZE configuration setting enables you to also limit the maximum response grid size that can be sent to the ASO target in one operation. Essbase splits the request grid into slices of data and sends multiple, smaller response grids to the target.

For example, if MAX_REQUEST_GRID_SIZE is set to one billion (1000000000) cells and MAX_RESPONSE_GRID_SIZE is set to one million (1000000) cells: 1000000000 / 1000000 = 1000. Essbase sends response grids to the ASO target in multiple slices of one thousand (1000) cells.

The amount of memory required to temporarily hold the response grid in the data target is proportional to the size of the request grid (MAX_REQUEST_GRID_SIZE). In the case of a huge request grid with millions of cells, the amount of memory required for the response grid to be sent in one operation could pose problems (for example, the system could reach memory boundaries or fail to allocate enough memory).

Syntax

MAX_RESPONSE_GRID_SIZE [appname [dbname]] n

appname—Optional. Specifies the application for which the response 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 the Essbase Server.
dbname—Optional. Specifies the database, in the application specified by appname, for which the response 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 the Essbase Server.
n—Specifies the size of the slice of the response grid to be sent to the data target.

The default value is one million (1000000) cells, which requires 8 MB of memory.

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

Example

MAX_RESPONSE_GRID_SIZE ASOSamp 500000

Limits the response grid to a half-million cells (which requires 4 MB of memory) for all databases associated with the ASOSamp application.