DYNCALCCACHEMAXSIZE

DYNCALCCACHEMAXSIZE defines, for each database on the server, the maximum amount of memory that Hyperion Essbase can allocate for its dynamic calculator cache.

Syntax

DYNCALCCACHEMAXSIZE 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 dynamic calculator cache.

Default value: 20 megabytes (20M, which is 20,971,520 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 (10 M).

Description

DYNCALCCACHEMAXSIZE specifies, in bytes, kilobytes, megabytes, or gigabytes, the maximum amount of memory that Hyperion Essbase can allocate for the dynamic calculator cache for each database. The specified value takes effect for all databases that are opened after the server is started.

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 dynamic calculator cache may improve retrieval performance by reducing the number of calls to the operating system to do memory allocations.

When the DYNCALCCACHEMAXSIZE setting is not equal to 0, you should also consider the following settings that affect how Hyperion Essbase uses dynamic calculator cache:

Example

DYNCALCCACHEMAXSIZE 30M

causes Hyperion Essbase to set 30 megabytes as the maximum size for the dynamic calculator cache.

Notes

Use DYNCALCCACHEWAITFORBLK and DYNCALCCACHEONLY to set or change how Hyperion Essbase handles the situation when it has reached the maximum dynamic calculator cache size and needs more memory in the dynamic calculator cache to store dynamically calculated blocks.