Essbase parallel calculation lets you streamline calculations by running them as concurrent, independent tasks. There are two kinds of parallel calculation available: FIXPARALLEL (newer method), and CALCPARALLEL (older method).

Essbase provides two ways of invoking a calculation on a block storage database:

• The calculation may be implicitly specified by the outline itself.

• The calculation may be explicitly specified by a calculation script that you create. The script contains formulas and calculation instructions.

Regardless of how a calculation is triggered, Essbase can execute the calculation in one of two modes:

• Serial calculation is the default. With serial calculation, each calculation pass is scheduled to run on a single processor. If invoked from a calculation script, the calculations are executed sequentially in the order in which they appear in the calculation script.

• Parallel calculation breaks each calculation pass into sub-tasks. The sub-tasks that can run independently of one another are scheduled to run simultaneously on up 128 threads for block storage and aggregate storage databases running on 64-bit operating systems. Each thread may be on a different processor.

Parallel calculation operations do not dynamically create threads, but instead use a set number of threads from a pre-created pool. You can customize the size of the thread pool using the WORKERTHREADS configuration setting.

• FIXPARALLEL Parallel Calculation

• CALCPARALLEL Parallel Calculation