CALCPARALLEL
This Essbase configuration setting enables parallel calculation, defining the number of processing threads.
Syntax
CALCPARALLEL [appname [dbname]] n
-
appname—Optional. Specifies that parallel calculation applies to all cubes on the application. If you specify a value for appname and do not specify a value for dbname, the setting applies to all cubes in the application. If you do not specify an application, you cannot specify a cube, and the setting applies to all applications and cubes.
-
dbname—Optional. Specifies that parallel calculation applies only to this cube. If you specify a value for dbname but do not include appname, the parameter is ignored, and parallel calculation is enabled for all applications and cubes.
-
n—A required parameter that specifies the number of threads to be made available for parallel calculation.
-
For block storage, an integer between 1-128. The default value, 1, specifies serial calculation: no parallel calculation takes place.
-
For aggregate storage, an integer from 1-128, with 2 the default value.
A value less than 1 is interpreted as the default size. A value greater than the maximum size is interpreted as the maximum size.
-
You must restart Essbase to initialize any change to the configuration.
Description
This setting enables CALCPARALLEL parallel calculation. For block storage databases, Essbase analyzes each pass of a calculation to determine whether parallel calculation would optimize the calculation. If it would not, Essbase uses serial calculation even if CALCPARALLEL is set to a number greater than 1.
Notes
-
With block storage cubes, Essbase dynamically calculates the number of task dimensions for parallel calculation by starting with a value of 1, determining how many potential tasks are generated, and increasing the number of task dimensions until an optimal limit is reached. If CALCTASKDIMS has been used to increase the number of tasks and to decrease the size of each task identified for parallel calculation, the number of sparse dimensions set with CALCTASKDIMS is used. See Identifying Additional Tasks for Parallel Calculation for more information about what kind of outlines or calculation scripts generate many empty tasks.
-
If you increase the number of threads for aggregate storage databases, since the aggregate storage cache is split up amongst the threads, consider increasing the size of aggregate storage memory cache.
-
When running a parallel calculation that includes the @XREF calculation function, the application associated with the database returns a timeout error if the number of threads specified for CALCPARALLEL is higher than the number of threads specified by the SERVERTHREADS setting. For example, the default value of SERVERTHREADS is 20. If you set CALCPARALLEL to 25, an application timeout error is generated.
-
To learn about a newer type of parallel calculation, see the FIXPARALLEL calculation command.
Example
CALCPARALLEL 3
Enables up to three threads to perform calculation tasks at the same time.