CALCCACHE TRUE | FALSE

Command

CALCCACHE TRUE | FALSE specifies whether Hyperion Essbase uses a calculator cache when calculating your database.

Syntax

CALCCACHE TRUE | FALSE

TRUE	Tells Hyperion Essbase to use a calculator cache when calculating the database. The default is TRUE.
FALSE	Tells Hyperion Essbase not to use a calculator cache when calculating the database.

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.

If required during a calculation, you can override this default setting using the SET CACHE command in a calc script.

You can specify the size of the calculator cache using the SET CACHE command in a calc script and the CALCCACHE{HIGH | DEFAULT | LOW} settings in the ESSBASE.CFG file.

When the CALCCACHE setting is set to TRUE, Hyperion 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 calc script).

Example

CALCCACHE TRUE
CALCCACHE FALSE

In ESSBASE.CFG, the parameter is not followed by a semicolon; in a calc script, the 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.

SET CACHE (calc script)

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