SET CALCTASKDIMS

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

Syntax

SET CALCTASKDIMS n;

n A required parameter, an integer specifying the number of sparse dimensions to be included when Analytic Services 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.

Analytic Services 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 Essbse Administrators Guide discussion of parallel calculation for more information.

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

Description

SET CALCTASKDIMS specifies how many of the sparse dimensions in an outline are used to identify potential tasks that can be run in parallel.

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

SET CALCPARALLEL
CALCTASKDIMS configuration setting
CALCPARALLEL configuration setting
Set Commands

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com