To use parallel calculation, enable it at the server level, application level, or database level using either of these methods:
Add or edit the appropriate configuration settings to the essbase.cfg file.
See CALCPARALLEL and CALCTASKDIMS in the Oracle Essbase Technical Reference.
Add the appropriate calculation commands to a calculation script.
See SET CALCPARALLEL and SET CALCTASKDIMS in the Oracle Essbase Technical Reference.
Parallel calculation settings use standard precedence rules:
Setting parallel calculation at the server level enables it for all calculations performed on all applications and databases on the server. You can disable parallel calculation for individual applications or databases by setting parallel calculation at the server level in the configuration file and then adding application-specific or database-specific entries in a calculation script.
To enable parallel calculation:
If you plan to enable parallel calculation in the configuration file, check the current status to see whether an entry exists.
Use the process described in Checking Current Parallel Calculation Settings.
Add or modify CALCPARALLEL in the essbase.cfg file on the server, or add SET CALCPARALLEL to a calculation script.
If needed, enable Essbase to use more than the one sparse dimension to identify tasks for parallel calculation.
Use the process described in Identifying Additional Tasks for Parallel Calculation.
If you added entries to the configuration file, restart the server.
Oracle recommends that you set the value of CALCPARALLEL to be one less than the number of processors available for calculation. This extra processor can then be used by either the operating system or by the Essbase process responsible for writing out dirty blocks from the cache.