DYNCALCCACHEMAXSIZE

This Essbase configuration setting specifies the maximum amount of memory allocated 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. 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.

This setting does not apply to aggregate storage databases.

Syntax

DYNCALCCACHEMAXSIZE [appname [dbname]] n

• appname—If you specify an application name, the setting applies to all databases within the application. If you do not specify an application name, the setting applies to all applications and databases on the server.

• dbname—If you specify a database name, the setting applies only to the database. If you do not also specify an application name, the setting applies to all applications and databases on the server.

• 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, Essbase does not use dynamic calculator cache.

  • Default value: 20 megabytes (20M, which is 20,971,520 bytes)

  • The maximum amount of memory that can be allocated is 256 GB:

  • 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).

Example

DYNCALCCACHEMAXSIZE 30M

Sets 30 megabytes as the maximum size for the dynamic calculator cache.