Executing Calculation Scripts

After creating and saving calculation scripts, you execute the scripts to perform the prescribed calculations. You can execute calculation scripts against databases for which you have Calculation permissions.

You can specify whether Essbase executes multiple calculations automatically or whether you are prompted for each calculation. See Setting Essbase Default Options. You can review syntax by opening scripts and clicking the Check Syntax button.

You can execute calculation scripts from Calculation Script Editor or Spreadsheet Add-in or by calculating the associated database. See Calculating Block Storage Databases.

  To execute calculation scripts from Calculation Script Editor:

  1. Perform an action:

    • From Enterprise View or a custom view, select a calculation script, right-click, and select Execute.

    • Open or create a calculation script, and click Execute.

    Essbase displays the Execute Calculation Script dialog box.

  2. If the script is saved to the file system or at the application, rather than the database level, select the database against which to execute the script.

  3. Optional: Select Execute in the background.

    As the script executes in the background, you can work in the console or exit the console. You cannot shut down Essbase Administration Server until script execution is completed.

  4. Click OK.

    Essbase runs the calculation script against the database. Error and status messages are displayed in the Messages pane at the bottom of the console window. If you executed the script in the background, an ID for the process is displayed. You can use the ID to track the status of the calculation in the Background Process Status window.

  5. Using a tool (such as Data Preview Grid or Spreadsheet Add-in), verify the calculation results.

  6. In the application log, review calculation information.

    See Opening Logs.

Related Information

Related Commands