1. Calculation and Query Reference for Oracle Essbase
  2. Calculation Commands
  3. Calculation Command List
  4. SET CALCPARALLEL

SET CALCPARALLEL

The SET CALCPARALLEL calculation command for Essbase enables parallel calculation in place of the default serial calculation.

If enabled, Essbase analyzes each pass of a calculation to determine whether parallel calculation is possible. If it is not possible, Essbase uses serial calculation.

This setting is not supported in hybrid aggregation mode, which is the default query processing mode.

Syntax

SET CALCPARALLEL n;

Parameters

n

A required parameter, an integer from 1 to 128, specifying the number of threads to be made available for parallel calculation. The default value specifies serial calculation: no parallel calculation takes place. Values 1 to 128 specify parallel calculation with 1 to 128 threads. Values of 0 specify serial calculation. Values less than 0 return an error. Values greater than the maximum are interpreted as the maximum (128).

Notes

  • If a specific calculation pass has stored members depending on dynamic members, Essbase uses hybrid aggregation mode. In this case, SET CALCPARALLEL is ignored, and the calculation will run in serial. Alternately, you can use FIXPARALLEL, which is supported in hybrid aggregation mode.
  • If you need to use the DATACOPY, DATAEXPORT, OR CLEARBLOCK commands, use FIXPARALLEL...ENDFIXPARALLEL for parallel calculation instead of this command.

  • A number of features are affected by parallel calculation. See CALCPARALLEL Parallel Calculation Guidelines for a list of these effects and for detailed information about how Essbase performs parallel calculation.

Example

SET CALCPARALLEL 3;

Enables up to three threads to be used to perform calculation tasks at the same time.