CALCCACHE

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

This setting does not apply to aggregate storage databases.

Syntax

CALCCACHE TRUE | FALSE

TRUE—Essbase uses a calculator cache when calculating the database. The default is TRUE.
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 your calculation performance. The size of the performance improvement depends on your 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 SETCACHE command in a calculation script and the CALCCACHE {HIGH | DEFAULT | LOW} settings in the essbase.cfg file.

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

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

Notes

For detailed information on setting the size of your calculator cache, see the Oracle Essbase Database Administrator's Guide.

Example

CALCCACHE TRUE
CALCCACHE FALSE

Note:

In essbase.cfg, the parameter is not followed by a semicolon; in a calculation script, the parameter must be followed by a semicolon.