SET CACHE

The SET CACHE command specifies the size of the calculator cache.

SET CACHE HIGH | DEFAULT | LOW | OFF | ALL;

HIGH, DEFAULT, and LOW Levels defining the size of the calculator cache. You set the values of HIGH, DEFAULT and LOW in the ESSBASE.CFG file. If you do not set the value of DEFAULT in the ESSBASE.CFG file, Hyperion Essbase uses a default value of 200,000 bytes. The maximum calculator cache size that you can specify is 200,000,000 bytes.

OFF Hyperion Essbase does not use a calculator cache.

ALL Hyperion Essbase uses a calculator cache, even when you do not calculate at least one full sparse dimension.

Description

SET CACHE specifies the size of the calculator cache.

Hyperion 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 the configuration of your database.

You can choose one of three levels. The size of the calculator cache at each level is defined using the CALCCACHE{HIGH | DEFAULT | LOW} settings in the ESSBASE.CFG file.

The level you choose depends on the amount of memory your system has available and the configuration of your database. For detailed information on setting the size of your calculator cache, see the Database Administrator's Guide.

You can specify whether, by default, Hyperion Essbase uses a calculator cache using the CALCCACHE TRUE | FALSE setting in the ESSBASE.CFG file. By default CALCCACHE is set to TRUE.

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

You can use this command more than once within a calc script.

You can display the calculator cache setting using the SET MSG command.

Notes

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

Example

If the ESSBASE.CFG file contains the following settings:

CALCCACHEHIGH  1000000
CALCCACHEDEFAULT  300000
CALCCACHELOW  200000

then:

SET CACHE HIGH;

sets a calculator cache of up to 1,000,000 bytes for the duration of the calc script.

SET CACHE DEFAULT;

sets a calculator cache of up to 300,000 bytes for the duration of the calc script.

SET CACHE LOW;

sets a calculator cache of up to 200,000 bytes for the duration of the calc script.

SET CACHE ALL;
SET CACHE LOW;

sets a calculator cache of 200,000 bytes to be used even when you do not calculate at least one, full sparse dimension.

SET CACHE OFF;

means that Hyperion Essbase does not use a calculator cache.

See Also

CALCCACHE TRUE | FALSE (ESSBASE.CFG file setting)
CALCCACHEHIGH | DEFAULT | LOW (ESSBASE.CFG file setting)
SET MSG (calc script)

HIGH, DEFAULT, and LOW	Levels defining the size of the calculator cache. You set the values of HIGH, DEFAULT and LOW in the `ESSBASE.CFG` file. If you do not set the value of DEFAULT in the `ESSBASE.CFG` file, Hyperion Essbase uses a default value of 200,000 bytes. The maximum calculator cache size that you can specify is 200,000,000 bytes.
OFF	Hyperion Essbase does not use a calculator cache.
ALL	Hyperion Essbase uses a calculator cache, even when you do not calculate at least one full sparse dimension.