DYNCALCCACHEBLKTIMEOUT

DYNCALCCACHEBLKTIMEOUT specifies the maximum number of seconds that Hyperion Essbase waits for space to become available in the dynamic calculator cache.

Syntax

DYNCALCCACHEBLKTIMEOUT n

n A number of seconds. May or may not include a decimal point. Any number less than 0.001 will be treated as 0.001. The default value is 10 seconds.

Description

Use DYNCALCCACHEBLKTIMEOUT to specify the maximum number of seconds that Hyperion Essbase should wait for space in the dynamic calculator cache in order to perform the requested calculation there. If Hyperion 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. 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 setting

DYNCALCCACHEBLKTIMEOUT 20

causes Hyperion Essbase to wait 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.

Notes

Use the DYNCALCCACHEBLKRELEASE setting to tell Hyperion 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 as TRUE.