1. Administering Profitability and Cost Management
  2. Calculating an Application
  3. Performing Single- and Multiple-POV Calculations Using Execution Control
  4. Performing Multi-POV Calculations
  5. Entering Calculation Settings
  6. About Optimizing for Reporting

About Optimizing for Reporting

When Optimize for Reporting is selected, Profitability and Cost Management runs aggregations on the Essbase cube when the calculation is complete. This improves performance for queries, reports, and analytics. You can also run this setting by itself.

These aggregations are dropped at the beginning of each calculation to improve calculation performance, so it is a good practice to select Optimize for Reporting only for running a final calculation before querying data, performing analytics, or running reports. For example, if you have three calculation jobs to run before you run reports, selecting this option before the first or second job adds unnecessary time to the calculation without providing a benefit.

Other helpful practices are as follows:

  • Optimize for Reporting is selected by default. Keep it selected unless you are running a single rule or a sequential series of several POVs and need to save processing time.

  • When running multiple concurrent calculation jobs, keep Optimize for Reporting selected for all jobs. Only the last to complete will perform the aggregation. This avoids redundant processing and prevents slow-down of jobs.