Calculating Data in Essbase

Data source types: : Oracle Essbase, Oracle Analytics Cloud - Essbase

In Oracle Smart View for Office, you can use a calculation script to calculate an Essbase database.

Additionally, when launched, a calculation script can prompt you to enter variable information, called runtime prompts. Calculation scripts and runtime prompts are created by your Essbase administrator for your specific system.

Note:

Essbase administrators: To define calculation scripts so that Smart View users can work with runtime prompts, refer to the Oracle Essbase Database Administrator's Guide, "Using Runtime Substitution Variables in Calculation Scripts Run in Smart View."

To select and launch a calculation script:

  1. From the Essbase ribbon, select Calculate.

    The Calculation Scripts dialog box is displayed.

  2. Under Cube, select a database from the list of databases that belong to this application.
  3. Under Calculation Script, select a script.
  4. If the calculation script includes runtime prompts, enter or select the input type specified by the runtime prompt, summarized in Table 5-1.

    Note:

    Depending on how the runtime prompts have been set up by your Essbase administrator, information for some prompts can be hand-typed. Ensure that the runtime prompts you enter are valid. You cannot launch a calculation script until all runtime prompt values are valid.

    Table 5-1 Runtime Prompt Input Types

    Icon Expected Input Type

    runtime prompt icon for one member selection

    One member selection—One member in the dimension can be selected. Click Select Members button to choose a single member in the Member Selection dialog box.

    Alternatively, if the field is enabled for editing, you may manually enter the member name, enclosed in quotation marks; for example:

    "California"

    runtime prompt icon for one member selections

    Multiple member selections—Two or more members in the dimension can be selected. Click Select Members button to choose multiple members in the Member Selection dialog box.

    Alternatively, if the field is enabled for editing, you may manually enter the member names, enclosed in quotation marks and separated by a comma; for example:

    "New York", "California"; "West", "Market"

    runtime prompt icon for text value

    Text value—A text value; for example:

    MyGrid

    Member names must be enclosed in quotation marks, separated by commas, and include a final semicolon (;). For example, type:

    "New York","California","West","Market";

    or

    "Oklahoma";

    runtime prompt icon for numerical value

    Numeric value—A numeric value; for example, type:

    1000

    or

    -2

    runtime prompt icon for date value

    Date value—A date value in the format required by your system; for example:

    mm/dd/yyyy

    or

    dd/mm/yyyy
  5. Click Launch.

    A status message tells you whether the calculation was successful or not. If the calculation was not successful, contact your Essbase administrator.