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 Block Mode and Cell Mode

Use of Block Mode and Cell Mode

  • Using block mode, where cells are grouped within the block and simultaneously calculated, is generally faster, but data dependencies must be carefully considered. For example, SalesYTD = CurMth + PriorMth should be calculated in cell mode so that each month is calculated in the order of the outline.
  • In cell mode, each cell is calculated sequentially in the order of the dense dimensions in the outline and is, generally, slower than block mode.
  • Use @CALCMODE to manually control whether block or cell mode is used.
  • Use debug mode application logs to verify calc mode. If a calculation is performed in block mode, no message is displayed. A log message is shown when calculations are performed in cell mode.