Specifies the number of sparse dimensions included in the identification of tasks for parallel calculation.
This setting does not apply to aggregate storage databases.
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 Essbase 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 Essbase Server.
n—Required. 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 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.
Values less than 0 treated differently than SET CALCTASKDIMS configuration setting.
You must restart Essbase Server to initialize any change to the configuration file.
CALCTASKDIMS specifies how many of the sparse dimensions in an outline are used to identify potential tasks that can be run in parallel.
A number of features are affected by parallel calculation. See the Oracle Essbase Database Administrator's Guide for a list of these effects and for detailed information about how Essbase performs parallel calculation.
Use this configuration setting only if your outline generates many empty tasks, thus reducing opportunities for parallel calculation. See the Oracle Essbase Database Administrator's Guide for more information about what kind of outlines or calculation scripts generate many empty tasks.
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.
SET CALCPARALLEL calculation command
SET CALCTASKDIMS calculation command