DYNCALCCACHEBLKTIMEOUT

This Essbase configuration setting specifies maximum time to wait for free space in the dynamic calculator cache.

This setting does not apply to aggregate storage cubes.

Syntax

DYNCALCCACHEBLKTIMEOUT [appname [dbname]] n

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.
n—A number of milliseconds. May or may not include a decimal point. Any number less than 1 will be treated as 1. The default value is 10000 milliseconds (10 seconds).

Description

Use this setting to specify the maximum number of seconds that Essbase should wait for space in the dynamic calculator cache in order to perform the requested calculation there. If Essbase waits the entire number of seconds specified in this setting, it then checks the DYNCALCCACHEBLKRELEASE setting to determine what to do next:

To make room in the dynamic calculator cache by temporarily swapping out blocks in the dynamic calculator cache that are inactive
If DYNCALCCACHEONLY is set to FALSE, to write and calculate the blocks in 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 database configuration.

Notes

Use the DYNCALCCACHEBLKRELEASE setting to tell Essbase where to store and calculate data blocks containing Dynamic Calc members if the wait for space in the dynamic calculator cache has exceeded the specified wait time.
The DYNCALCCACHEBLKTIMEOUT configuration setting is meaningful only when the DYNCALCCACHEWAITFORBLK configuration setting is set to TRUE.

Example

DYNCALCCACHEBLKTIMEOUT 20000

Essbase waits up to 20 seconds for space in the dynamic calculator cache before checking the DYNCALCCACHEBLKRELEASE setting to determine the next step to take before performing the requested calculation.