CALCCACHE HIGH | DEFAULT | LOW

Command

CALCCACHE {HIGH | DEFAULT | LOW} sets the HIGH, DEFAULT, and LOW values for the calc script SET CACHE command.

Syntax

CALCCACHEHIGH | CALCCACHEDEFAULT | CALCCACHELOW n

where HIGH, DEFAULT, and LOW are levels:

HIGH	Maximum calculator cache size that a user can choose to use during calculation.
DEFAULT	Default calculator cache size.
LOW	Minimum calculator cache size that a user can choose to use during calculation.
n	Integer value for each level. It represents the size of the calculator cache in bytes.

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

The maximum calculator cache size that you can specify is 200,000,000 bytes.

Description

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

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

You can specify whether Hyperion Essbase uses a calculator cache by default using the CALCCACHE TRUE | FALSE command in the ESSBASE.CFG file. If required during a calculation, override this default setting using the SET CACHE command in a calc script.

Example

If the ESSBASE.CFG file contains the following settings:

CALCCACHEHIGH  1000000
CALCCACHEDEFAULT 300000
CALCCACHELOW  200000

then you can use the following SET CACHE setting commands in a calc script:

SET CACHE HIGH;

sets a calculator cache of 1,000,000 Bytes for the duration of the calc script.

SET CACHE DEFAULT;

sets a calculator cache of 300,000 Bytes for the duration of the calc script.

SET CACHE LOW;

sets a calculator cache of 200,000 Bytes for the duration of the calc script.

In ESSBASE.CFG, a parameter is not followed by a semicolon; in a calc script, a parameter must be followed by a semicolon.

Notes

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

See Also

SET CACHE (calc script command)

Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.