Sets default value for the calculation script SET CACHE command.
This setting does not apply to aggregate storage databases.
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, Analytic Services uses a default value of 200,000 bytes.
Analytic Services 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 Database Administrator's Guide.
You can specify whether Analytic Services 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.
essbase.cfg
, a parameter is not followed by a semicolon; in a calculation script,
a parameter must be followed by a semicolon.
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;
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.
CALCCACHEHIGH
CALCCACHELOW
SET CACHE (calculation script command)
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |