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

CALCCACHEDEFAULT

This Essbase configuration setting specifies a default value for the calculation script SET CACHE command.

This setting does not apply to aggregate storage databases.

Syntax

CALCCACHEDEFAULT [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 databases in the specified application.

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

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

  • dbname—Optional. Specifies the database, 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 default calculator cache size, in bytes. If you do not set a default value, it is 200,000 bytes.

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 database configuration.

You can specify whether Essbase uses a calculator cache by default using the CALCCACHE 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.