DYNCALCCACHECOMPRBLKBUFSIZE

DYNCALCCACHECOMPRBLKBUFSIZE specifies the size of the buffer area that Hyperion Essbase temporarily uses to store compressed blocks in order to make more space available in the dynamic calculator cache.

Syntax

DYNCALCCACHECOMPRBLKBUFSIZE n

n

An integer expressed in bytes (B), kilobytes (K), megabytes (M), or gigabytes (G)

Minimum value: 0 megabytes (0 M). If the value is 0, Hyperion Essbase does not use the compressed block buffer.

Default value: 1 megabyte (1M, which is 1,048,576 bytes)

If a value is given without a B, K, M, or G qualifier, it is assumed the value is in bytes.

The qualifier can be in upper or lowercase and can be entered adjacent to the value (10M) or separated by a space (1M)

Description

In order to make space available in the dynamic calculator cache, Hyperion Essbase uses the value specified by the DYNCALCCACHECOMPRBLKBUFSIZE configuration setting to size the dynamic calculator cache compressed-block buffer. Hyperion Essbase temporarily stores compressed blocks from the dynamic calculator cache into this buffer under the following circumstances:

The area allocated in the dynamic calculator cache has reached the maximum allowed (specified by DYNCALCCACHEMAXSIZE) and Hyperion Essbase requires additional space for blocks to be calculated in the current query.
DYNCALCCACHEWAITFORBLK is set as TRUE and the wait period specified by DYNCALCCACHEBLKTIMEOUT has been reached.
DYNCALCCACHEBLKRELEASE is set as TRUE, indicating Hyperion Essbase should release dynamic calculator cache area.

The dynamic calculator cache compressed-block buffer is an area in memory where Hyperion Essbase compresses and temporarily stores blocks from the dynamic calculator cache to free space for other blocks for other calculations. When space is again available, Hyperion Essbase decompresses blocks stored in the compressed-block buffer and returns them to 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

DYNCALCCACHECOMPRBLKBUFSIZE 1000000

causes Hyperion Essbase to set 1,000,000 (one million) bytes as the size for the dynamic calculator cache compressed-block buffer.

Notes

Hyperion Essbase uses the temporary compressed-block buffer only when the DYNCALCCACHEBLKRELEASE configuration parameter is set as TRUE and the DYNCALCCACHECOMPRBLKBUFSIZE setting is greater than 0.