1. Designing and Maintaining Essbase Cubes
  2. Optimizing Calculations
  3. Monitoring and Tracing Calculations
  4. SET MSG SUMMARY and SET MSG DETAIL

SET MSG SUMMARY and SET MSG DETAIL

You can use the SET MSG SUMMARY and SET MSG DETAIL calculation commands in a calculation script to do the following:

  • Display calculation settings, for example, whether completion notice messages are enabled

  • Provide statistics on the number of data blocks created, read, and written

  • Provide statistics on the number of data cells calculated

SET MSG DETAIL also provides an information message every time Essbase calculates a data block. SET MSG DETAIL is useful for reviewing the calculation order of data blocks and for testing intelligent recalculations.

Caution:

Because SET MSG DETAIL causes a high processing overhead, use it only during test calculations.

SET MSG SUMMARY causes a processing overhead of approximately 1% to 5%, depending on database size, and is therefore appropriate for all calculations.