CALCCACHEDEFAULT

Sets default value for the calculation script SET CACHE command.

This setting does not apply to aggregate storage databases.

Syntax

CALCCACHEDEFAULT n

CALCCACHEDEFAULT is the level and n is the size for the level, default in this example, the default calculator cache size, in bytes.

If you do not set the value of DEFAULT, Essbase uses a default value of 200,000 bytes.

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.

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

You can specify whether Essbase uses a calculator cache by default using the CALCCACHE setting in the essbase.cfg file. If required during a calculation, override this default setting using the SET CACHE command in a calculation script.

Notes

Example

Assume the essbase.cfg file contains these settings:

CALCCACHEHIGH  1000000
CALCCACHEDEFAULT 300000
CALCCACHELOW  200000

You could then use the following SET CACHE commands in a calculation script:

SET CACHE HIGH;

SET CACHE DEFAULT;

SET CACHE LOW;

See Also

CALCCACHEHIGH

CALCCACHELOW

SET CACHE (calculation script command)