Checking Script Syntax

Calculation Script Editor and Report Script Editor provide syntax checkers that identify and explain syntax errors in calculation and report scripts. For example, syntax checkers identify incorrectly spelled function names and omitted end-of-line semicolons. Syntax checkers also verify dimension names, member names, and, for calculation scripts, custom-defined macros and functions against the database with which a script is associated.

Syntax checkers cannot identify semantic (logic) errors. Semantic errors occur when scripts do not produce the expected results. To identify semantic errors, execute scripts and review the results, to ensure that the results are as you expect.

For syntax checks and script executions, error and status messages are displayed in the Messages pane at the bottom of the console window. Syntax checks and executions produce identical messages.

  To check calculation-script or report-script syntax:

  1. Open or create a script.

  2. If the outline tree in the editor window is not populated, associate an outline with the script.

  3. Select Syntax, and then Check syntax.

    Essbase displays the results of the syntax check in the Messages pane at the bottom of the console window. Each error message is displayed individually.

  4. If an error is associated with a line number, go directly to the line by right-clicking in the script area and selecting Go to line.

  5. If an error is associated with multiple line numbers, repeat step 3 for each line number.

Related Information