SET CALCTASKDIMS

Specifies the number of sparse dimensions included in the identification of tasks for parallel calculation.

Syntax

SET CALCTASKDIMS n;
ParameterDescription

n

A required parameter, an integer specifying the number of sparse dimensions to be included when Essbase identifies tasks that can be performed at the same time.

The default value, 1, indicates that only the last sparse dimension in the outline will be used to identify tasks. A value of 2, for example, indicates that the last and second-to-last sparse dimensions in the outline are used.

Because each unique combination of members from the selected sparse dimensions is a potential task, the potential number of parallel tasks is the product of the number of members of the selected dimensions. The maximum value is the number of sparse dimensions in the outline.

Essbase issues an error if the value is less than 1. A value greater than the number of sparse dimensions in the outline is interpreted as the largest valid value.

Using the calculator bitmap cache can affect this value. See the Oracle Essbase Database Administrator's Guide discussion of parallel calculation for more information.

Note:

Values less than 0 are treated differently than they are by the CALCTASKDIMS configuration setting.

Notes

Example

SET CALCTASKDIMS 2;

Specifies that the last two sparse dimensions in the outline will be used to identify potential tasks to be performed at the same time during a calculation pass.

See Also