CALCTASKDIMS

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

This setting does not apply to aggregate storage databases.

Syntax

CALCTASKDIMS [appname [dbname]] n

appname Optional. CALCTASKDIMS applies to all databases on the named application. 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. If you do not specify an application, you cannot specify a database, and the setting applies to all applications and databases on the Analytic Server.
dbname Optional. Database name to which CALCTASKDIMS applies. If you specify a value for dbname but do not include appname, the parameter is ignored and the setting applies to all applications and databases on the Analytic Server.
n Required. 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 is 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 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.

Any value less than 1 is interpreted as 1, any value greater than the number of sparse dimensions in the outline is converted to the largest valid value.

Note: Values less than 0 treated differently than SET CALCTASKDIMS configuration setting.

You must restart Analytic Server to initialize any change to the configuration file.

Description

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

CALCTASKDIMS Sample Basic 2
Specifies that for application Sample and database Basic, the last two sparse dimensions in an outline will be used to identify potential tasks to perform at the same time during a calculation pass.

See Also

CALCPARALLEL
SET CALCPARALLEL calculation command
SET CALCTASKDIMS calculation command

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