After you execute a calculation script, you can check the results of the calculation in Smart View or Spreadsheet Add-in.
Essbase provides the following information about the executed calculation script:
To display more-detailed information, you can use the SET MSG SUMMARY, SET MSG DETAIL, and SET NOTICE commands in a calculation script. See Specifying Global Settings for a Database Calculation.
You can use these messages to understand how the calculation is performed and to tune it for the next calculation.
Where you view this information depends on the tool used to execute the calculation script.
Administration Services, Spreadsheet Add-in, and Smart View—Application log
MaxL—Standard output (command-line window)
The amount of information depends on the message level set in MaxL Shell.
ESSCMD—ESSCMD window or standard output (command-line window)
The amount of information depends on the message level set in ESSCMD.