Specifies whether Analytic Services uses a calculator cache when calculating the database.
This setting does not apply to aggregate storage databases.
CALCCACHE TRUE | FALSE
TRUE | Tells Analytic Services to use a calculator cache when calculating the database. The default is TRUE. |
FALSE | Tells Analytic Services not to use a calculator cache when calculating the database. |
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.
If required during a calculation, you can override this default setting using the SET CACHE command in a calculation script.
You can specify the size of the calculator cache using the SETCACHE command in a calculation script
and the CALCCACHE {HIGH | DEFAULT | LOW} settings in the essbase.cfg
file.
When the CALCCACHE setting is set to TRUE, Analytic Services uses the calculator cache providing that:
For detailed information on setting the size of your calculator cache, see the Database Administrator's Guide.
CALCCACHE TRUE CALCCACHE FALSE
In essbase.cfg
, the parameter is not followed by a semicolon; in a calculation script,
the parameter must be followed by a semicolon.
SET CACHE (calculation script)
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |