DYNCALCCACHEWAITFORBLK

DYNCALCCACHEWAITFORBLK defines, for all databases on the server, how Hyperion Essbase handles the situation when it has fully allocated the amount of memory in the dynamic calculator cache defined by the DYNCALCCACHEMAXSIZE configuration setting.

Syntax

DYNCALCCACHEWAITFORBLK TRUE¦FALSE

TRUE Tells Hyperion Essbase to wait for memory to be freed in the dynamic calculator cache.

FALSE

If allowed by the DYNCALCCACHEONLY setting, tells Hyperion Essbase to perform calculations on these blocks in memory outside the dynamic calculator cache.

If the DYNCALCCACHEONLY setting is TRUE, tells Hyperion Essbase to generate an error message.

The default setting is FALSE.

Description

Use DYNCALCCACHEWAITFORBLK to set or change how Hyperion Essbase handles the situation when it needs additional memory to store blocks in the dynamic calculator cache for the database.

When the setting is TRUE, Hyperion 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 FALSE, instead of waiting for area in the dynamic calculator cache, Hyperion Essbase stores and calculates data blocks for the current query in memory outside the dynamic calculator cache. If the DYNCALCCACHEONLY setting is TRUE, Hyperion Essbase generates an error message

The dynamic calculator cache is a memory buffer that holds data blocks that are expanded to include dynamically calculated members. Hyperion 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 database configuration.

Example

The configuration settings

DYNCALCCACHEONLY FALSE
DYNCALCCACHEWAITFORBLK FALSE

cause Hyperion Essbase 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.

Notes

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

TRUE	Tells Hyperion Essbase to wait for memory to be freed in the dynamic calculator cache.
FALSE	If allowed by the DYNCALCCACHEONLY setting, tells Hyperion Essbase to perform calculations on these blocks in memory outside the dynamic calculator cache. If the DYNCALCCACHEONLY setting is TRUE, tells Hyperion Essbase to generate an error message.