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. Environment Setting

Environment Setting

Consider the following best practices while using commands that instruct a business rule how to execute the calculation.

  • SET UPDATECALC OFF turns off intelligent calculation, which is best practice for business rules that use cross dimensional operators and may have multiple users accessing the same data block combinations. Using this command is a best practice for applications where multiple users write to the database. If you use intelligent calculation, ensure it produces the expected results.
  • SET AGGMISSG OFF should be set for applications where versions are standard target or where non-leaf data regions are used and cannot be excluded during calculation.

    Using SET AGGMISSG ON is beneficial if the application design has a Standard Bottom Up versions setup where data is loaded at level 0.

  • SET NOTICE and SET MSG should only be used in development environments for individual calculation analysis. These commands should be removed for production environments or after calculation analysis is complete.
  • SET EMPTYMEMBERSETS ON should be used when Run Time Prompts (RTP) are included in FIX statements so that empty sets are not calculated. This prevents a calculation from running on all members when the set is empty.