CALCCACHE

The CALCCACHE configuration setting specifies whether Essbase uses a calculator cache to manage data blocks during calculation. Using the calculator cache improves performance. You can specify the size of the cache using the SET CACHE command in a calculation script, or the CALCCACHE {HIGH | DEFAULT | LOW} configuration settings.

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

Syntax

CALCCACHE [appname [dbname]] TRUE | FALSE

appname—Optional. Specifies the application for which the setting applies.

If you specify a value for appname and do not specify a value for dbname, the setting applies to all cubes in the specified application.

To enable the setting for a specific cube, you must specify an application and cube.

If you do not specify an application, you cannot specify a cube, and the setting applies to all applications and cubes on the Essbase instance.
dbname—Optional. Specifies the database (cube), in the application specified by appname, for which the setting applies.

If you specify a value for dbname but do not specify a value for appname, your specification is ignored.
TRUE—Essbase uses a calculator cache when calculating the cube. This is the default.
FALSE—Essbase does not use a calculator cache when calculating the cube.

Description

If required during a calculation, you can override this default setting using the SET CACHE command in a calculation script.

When CALCCACHE is set to TRUE, Essbase uses the calculator cache, providing that:

The cube has at least two sparse dimensions.
You calculate at least one full sparse dimension (unless you specify the SET CACHE ALL option in a calculation script).

Example

CALCCACHE Sample Basic FALSE