Process for Creating Calculation Scripts

Use this process to create a calculation script:

  1. Create a calculation script or open an existing calculation script.

    See “Creating Scripts” or “Opening Scripts” in the Oracle Essbase Administration Services Online Help.

  2. Enter or edit the contents of the calculation script.

    See “About Calculation Script Editor” in the Oracle Essbase Administration Services Online Help for information about:

    • Associating a script with an outline

    • Searching an outline tree for members

    • Inserting dimensions, members, and aliases in a script from an outline tree

    • Inserting functions and commands in a script from a tree

    • Using syntax autocompletion

    • Checking script syntax

    • Executing scripts

    • Viewing color-coded script elements

    • Searching for text in a script

    • Changing fonts

  3. Validate the calculation script.

    See Checking Syntax.

  4. Save the calculation script.

    See Saving Calculation Scripts.

  5. Execute the calculation script.

    See Executing Calculation Scripts.

  6. Check the results of the calculation script.

    See Checking Calculation Results.

  7. If necessary, perform other operations on the calculation script.

    In the Oracle Essbase Administration Services Online Help, see the following topics:

    • “Locking and Unlocking Objects”

    • “Copying Scripts”

    • “Renaming Scripts”

    • “Deleting Scripts”

    • “Printing Scripts”