Enables parallel calculation, defining the number of processing threads.
CALCPARALLEL [appname [dbname]] n
appname—Optional. Specifies that parallel calculation 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. Specifies that parallel calculation applies only to the database named. 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 databases on the Essbase Server.
n—A required parameter that specifies the number of threads to be made available for parallel calculation.
For block storage on 32-bit platforms, an integer from 1-4. For block storage on 64-bit platforms, an integer between 1-8. The default value, 1, specifies serial calculation: no parallel calculation takes place.
For aggregate storage, an integer from 1-8, 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 Server to initialize any change to the configuration file.
This setting enables 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.
For detailed information about how Essbase performs parallel calculation with block storage databases, see the Oracle Essbase Database Administrator's Guide.
With block storage databases, if your outline generates many empty tasks, thus reducing opportunities for parallel calculation, consider setting the CALCTASKDIMS configuration setting to increase the number of tasks and to decrease the size of each task identified 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.
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. For details, see the Oracle Essbase Database Administrator's Guide for information about aggregate storage cache.
CALCPARALLEL 3
Enables up to three threads to perform calculation tasks at the same time.
SET CALCPARALLEL calculation command
SET CALCTASKDIMS calculation command