Specifies whether Essbase uses a calculator cache when calculating the database.
This setting does not apply to aggregate storage databases.
CALCCACHE TRUE | FALSE
TRUE—Essbase uses a calculator cache when calculating the database. The default is TRUE.
FALSE—Essbase does not use a calculator cache when calculating the database.
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.
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, 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 in a calculation script).
For detailed information on setting the size of your calculator cache, see the Oracle Essbase Database Administrator's Guide.
CALCCACHE TRUE CALCCACHE FALSE
Note: | 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)