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 BottomUp and TopDown Calculations

Use of BottomUp and TopDown Calculations

  • Add calculation function @CALCMODE(BOTTOMUP) or calculation command SET FRMLBOTTOMUP to calculate only existing blocks (BOTTOMUP) instead of potential blocks (TOPDOWN).
  • Because TOPDOWN calculations calculates all potential data blocks with the member, remove any irrelevant members within sparse dimensions.
  • Thoroughly test calculations using BOTTOMUP to ensure that blocks are created correctly when using @CALCMODE.
  • When using BOTTOMUP calculation, test the calculation completely by clearing data and rerunning the calculation to determine that all blocks are created correctly.
  • Use debug mode application logs to verify calc mode. If a calculation is performed BOTTOMUP, no message is displayed. A log message is displayed if calculations are performed TOPDOWN.