Checking Calculation Results

After you execute a calculation script, you can check the results of the calculation in Smart View.

Essbase provides the following information about the executed calculation script:

  • Calculation order of the dimensions for each pass through the database

  • Total calculation time

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.

  • Smart View—Application log

  • MaxL—Standard output (command-line window)

    The amount of information depends on the message level set in MaxL Shell.