Enabling Parallel Calculation

To use parallel calculation, enable it at the server level, application level, or database level using either of these methods:

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.

Caution!

Read this entire chapter before attempting to enable parallel calculation.

  To enable parallel calculation:

  1. 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.

  2. Add or modify CALCPARALLEL in the essbase.cfg file on the server, or add SET CALCPARALLEL to a calculation script.

  3. 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.

  4. If you added entries to the configuration file, restart the server.

  5. Run the calculation.

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.

Tip:

You can combine the use of CALCPARALLEL and SET CALCPARALLEL if the site requires it. For example, you can set CALCPARALLEL as off at the server level, and use a calculation script to enable and disable parallel calculation as needed.