DYNCALCCACHEBLKTIMEOUT

Use the DYNCALCCACHEBLKTIMEOUT configuration 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.

DYNCALCCACHEBLKTIMEOUT configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.

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

If Essbase waits the entire number of seconds specified by DYNCALCCACHEBLKTIMEOUT, 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 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.

The dynamic calculator cache can improve retrieval performance by reducing the number of calls to the operating system for memory allocations. The size of the performance improvement from using the dynamic calculator cache 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.