CALCCACHE

Specifies whether Essbase uses a calculator cache when calculating the database.

This setting does not apply to aggregate storage 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 databases in the specified application.

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

  If you do not specify an application, you cannot specify a database, and the setting applies to all applications and databases on the Essbase instance.

• dbname—Optional. Specifies the database, 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 database. This is the default.

• FALSE—Essbase does not use a calculator cache when calculating the database.

Description

Essbase uses the calculator cache to create and track data blocks during calculation. Using the calculator cache significantly improves calculation performance. The size of the performance improvement depends on the database configuration.

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

You can specify the size of the calculator cache using the SET CACHE command in a calculation script and the CALCCACHE {HIGH | DEFAULT | LOW} configuration settings.

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

• The database has at least two sparse dimensions.

• You calculate at least one full sparse dimension (unless you specify the CALCCACHE ALL option in a calculation script).

Example

CALCCACHE Sample Basic FALSE