1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. CALCCACHELOW

CALCCACHELOW

This Essbase configuration sets the low value for the calculation script SET CACHE command.

This setting does not apply to aggregate storage cubes.

Syntax

CALCCACHELOW [appname [dbname]] n

  • appname—Optional. Specifies the application for which the setting applies.

    If you specify a value for appname and do not specify a value for dbname, the setting applies to all cubes in the specified application.

    To enable the setting for a specific cube, you must specify an application and cube.

    If you do not specify an application, you cannot specify a database, and the setting applies to all applications and cubes on Essbase Server.

  • dbname—Optional. Specifies the database (cube), in the application specified by appname, for which the setting applies.

    If you specify a value for dbname but do not specify a value for appname, your specification is ignored.

  • n—The minimum calculator cache size, in bytes. By default, the minimum is 200,000.

Description

Essbase uses the calculator cache to create and track data blocks during calculation. Using the calculator cache significantly improves calculation performance. The size of the performance improvement depends on the cube configuration.

You can specify whether Essbase uses a calculator cache by default using the CALCCACHE configuration setting. If required during a calculation, override this default setting using the SET CACHE command in a calculation script.

Example

See Also

Assume the Essbase configuration specifies these settings: 

CALCCACHEHIGH  1000000
CALCCACHEDEFAULT 300000
CALCCACHELOW  200000

Note:

In the Essbase configuration, a parameter is not followed by a semicolon; in a calculation script, a parameter must be followed by a semicolon.

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.

The SET CACHE calculation command.