1. Oracle Enterprise Performance Management Cloud Operations Guide
  2. Troubleshooting EPM Cloud Issues
  3. Troubleshooting Business Rules and Member Formula Errors and Performance
  4. Best Practices
  5. Use of SET CALCPARALLEL and FIXPARALLEL Calculation Commands

Use of SET CALCPARALLEL and FIXPARALLEL Calculation Commands

  • For multi-user applications with the potential for rules running concurrently, run business rules in serial mode.
  • Only use SET CALCPARALLEL around full sparse dimension aggregations in batch calculations.
  • Parallel calculation is not recommended for small scripts; for example, scripts that run for less than 20 seconds because the overhead for creating parallelism may outweigh the benefit.
  • Always test SET CALCPARALLEL to ensure that it is beneficial. Sometimes serial calculations or calculations with lower levels of parallelism can yield better results. This is especially true for short running business rules because of the overhead in calculating how to spread the task pool, which can exceed the time saved by the use of parallel calculation. Also, if the calculation pass in a rule that fails uses SET CALCPARALLEL, remove it for debug purposes.
  • Test to determine if FIXPARALLEL provides better results than SET CALCPARALLEL Use Oracle Hyperion Calculation Manager in debug mode to review logs.

  • Always consider user concurrency when using SET CALCPARALLEL and FIXPARALLEL.

Note:

You must thoroughly test all use of CALCPARALLEL and FIXPARALLEL for expected concurrency to achieve the most consistent execution time. Be aware that an a processing overhead is involved in using parallel processing. You should carefully consider how Oracle Essbase calculates the task pool to determine how to spread out processing. Never assume that the use of SET CALCPARALLEL or FIXPARALLEL (or their higher values) will yield better results than a lower SET CALCPARALLEL or FIXPARALLEL value. In many cases, serial processing gives better performance, even in a single user test.

Although the business rule itself may not contain CALCPARALLEL and FIXPARALLEL, your scripts or templates may have them. In such cases, remove them from scripts or templates.

After taking out CALCPARALLEL and FIXPARALLEL, redeploy your rules.

For more information, see FIXPARALLEL...ENDFIXPARALLEL in Oracle® Essbase Technical Reference.