DYNCALCCACHEWAITFORBLK

This configuration setting specifies whether Essbase should wait for memory to be freed in the dynamic calculator cache, or use outside memory.

This setting does not apply to aggregate storage cubes.

Syntax

DYNCALCCACHEWAITFORBLK [appname [dbname]] TRUE | FALSE

appname—If you specify an application name, the setting applies to all cubes within the application. If you do not specify an application name, the setting applies to all applications and cubes on the server.
dbname—If you specify a database (cube) name, the setting applies only to this cube. If you do not also specify an application name, the setting applies to all applications and cubes on the server.
TRUE—Tells Essbase to wait for memory to be freed in the dynamic calculator cache.
FALSE—This is the default. If allowed by the DYNCALCCACHEONLY setting, tells Essbase attempt to perform calculations on these blocks in memory outside the dynamic calculator cache.

If the DYNCALCCACHEONLY setting is TRUE, tells Essbase to generate an error message instead of using memory outside the dynamic calculator cache.

Description

Use this setting to set or change how Essbase handles the situation when it needs additional memory to store blocks in the dynamic calculator cache for the cube.

When the setting is TRUE, Essbase waits to store and calculate data blocks in the dynamic-calculator-cache area that is currently in use by other queries.

When the setting is FALSE, if the DYNCALCCACHEONLY setting is also FALSE, instead of waiting for area in the dynamic calculator cache, Essbase attempts to store and calculate data blocks for the current query in memory outside the dynamic calculator cache. If the DYNCALCCACHEONLY setting is TRUE, Essbase generates an error message instead of using memory outside the dynamic calculator cache.

The dynamic calculator cache is a memory buffer that holds data blocks that are expanded to include dynamically calculated members. Essbase allocates memory in the dynamic calculator cache to store these blocks during retrievals or calculations that involve dynamically calculated members.

Using the dynamic calculator cache may improve retrieval performance by reducing the number of calls to the operating system to do memory allocations. The size of the improvement depends on your configuration.

Notes

Use the DYNCALCCACHEBLKTIMEOUT setting to specify the maximum number of seconds that Essbase waits for space in the dynamic calculator cache.

Example

DYNCALCCACHEONLY FALSE
DYNCALCCACHEWAITFORBLK FALSE

Essbase attempts to perform the block calculation in memory outside the dynamic calculator cache, instead of waiting for space to become available in the dynamic calculator cache.