CALCPARALLEL

Enables parallel calculation, defining the number of processing threads.

Syntax

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-64. For block storage on 64-bit platforms, 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 Server to initialize any change to the configuration file.

Description

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.

Notes

  • 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, Essbase dynamically calculates the number of cutting dimensions for parallel calculation by starting with a value of 1, determining how many potential tasks are generated, and increasing the number of cutting 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 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.

  • 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 the CALCPARALLEL configuration setting is higher than the number of threads specified by the SERVERTHREADS configuration 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 another type of parallel calculation, see FIXPARALLEL...ENDFIXPARALLEL.

Example

CALCPARALLEL 3

Enables up to three threads to perform calculation tasks at the same time.

See Also

CALCTASKDIMS

SET CALCPARALLEL calculation command

SET CALCTASKDIMS calculation command

SERVERTHREADS

FIXPARALLEL...ENDFIXPARALLEL

WORKERTHREADS

@XREF calculation function

@XWRITE calculation function