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

See Also

SET CACHE command

CALCCACHEHIGH

CALCCACHEDEFAULT

CALCCACHELOW