1. Using Oracle Essbase
  2. Calculate Cubes
  3. Create Calculation Scripts

Create Calculation Scripts

Essbase calculation scripts specify how block storage cubes are calculated and, therefore, override outline-defined cube calculations. For example, you can calculate cube subsets or copy data values between members.

You create calculation scripts using a script editor in the Essbase web interface.

Calculation scripts do not apply to aggregate storage applications.

  1. On the Applications page, open the application and then open the database (cube).
  2. Click Scripts, and then click Calculation Scripts.
  3. Click Create to create a new calculation script.
  4. Enter a name for the new script.
  5. If member names are required in your calculation script, drill into the Member Tree to find the members you want to add.
  6. Double-click dimension or member names to insert them into the script.
  7. If function names are required in your calculation script, use the Function Name menu to find calculation functions and add them to the script.

    See the Function description under the menu to read descriptions of each function.

  8. Click Validate before saving your script.

    Validating a script verifies the script syntax. For example, incorrectly spelled function names and omitted end-of-line semicolons are identified. Validation also verifies dimension names and member names.

  9. Correct any validation errors.
  10. Click Save.
  1. On the Application page, expand the application.
  2. From the Actions menu, to the right of the cube name, launch the inspector.
  3. Select the Scripts tab, and then select the Calculation Scripts tab.
  4. Click Add Image of the Add icon. to create a new calculation script.
  5. Enter a name in the Script Name field.
  6. If member names are required in your calculation script, drill into the Member Tree to find the members you want to add.

    Right-click dimension or member names to insert them into the script.

  7. If function names are required in your calculation script, use the Function Name menu to find calculation functions and add them to the script.

    See the Function description under the menu to read descriptions of each function.

  8. Click Validate before saving your script.

    Validating a script verifies the script syntax. For example, incorrectly spelled function names and omitted end-of-line semicolons are identified. Validation also verifies dimension names and member names.

  9. Correct any validation errors.
  10. Click Save.

To learn about calculation script logic, see Developing Calculation Scripts for Block Storage Databases.

To learn about calculation functions and commands, see Calculation Functions and Calculation Commands.