Sets the high value for the calculation script SET CACHE command.
This setting does not apply to aggregate storage databases.
CALCCACHEHIGH n
CALCCACHEHIGH is the level and n is the maximum calculator cache size, in bytes, that a user can choose to use during calculation. The maximum calculator cache size that you can specify is 200,000,000 bytes.
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 TRUE | FALSE command in the essbase.cfg file. If required during a calculation, override this default setting using the SET CACHE command in a calculation script.
In essbase.cfg, a setting parameter is not followed by a semicolon; in a calculation script, a parameter must be followed by a semicolon.
For detailed information on setting the size of your calculator cache, see the Oracle Essbase Database Administrator's Guide.
Assume the essbase.cfg file contains these settings:
CALCCACHEHIGH 1000000 CALCCACHEDEFAULT 300000 CALCCACHELOW 200000
You could use the following SET CACHE calculator commands in a calculation script:
SET CACHE HIGH;
Sets a calculator cache of 1,000,000 bytes for the duration of the calculation script.
SET CACHE DEFAULT;
Sets a calculator cache of 300,000 bytes for the duration of the calculation script.
SET CACHE LOW;
Sets a calculator cache of 200,000 bytes for the duration of the calculation script.
SET CACHE (calculation script command)