Execute Calculations

After creating and saving Essbase calculation scripts, you can execute them in the script editor and perform the calculations on data loaded in your cube.

1. Create your calculation script, or upload an existing calculation script.
2. Navigate to a script,
   • In the Redwood Interface
     1. On the Applications page, open the application and then open the database (cube).
     2. Click Scripts and click Calculation Scripts.
     3. Select the script you want to execute.
   • In the Classic Web Interface
     1. On the Applications page, expand an application, and select a cube.
     2. From the Actions menu, to the right of the cube name, launch the inspector.
     3. Select Scripts, and select the script you want to execute.
3. In the script editor, click Execute and then select either Run in Foreground or Run in Background.
   • If you choose Run in Forground, Script execution in progress is displayed and you can't close the script editor until the calculation is completed.
   • If you choose Run in Background, you can close the script editor and later check the Jobs page (from the Applications page, select Jobs) for the status of the calculation.

You can also execute calculation scripts from the Jobs page or from Smart View (whether or not they contain point-of-view based substitution variables).

Calculation scripts can contain runtime substitution variables designed to derive the calculation scope from the point of view (POV) in a Smart View grid. These types of calculation scripts can only be executed from Smart View, because the point of view can only be known from a Smart View grid.

Assign access to execute specific calculation scripts:

1. Ensure that you are logged into the Essbase web interface as a service administrator or power user.
2. Navigate to the Roles tab for your calculation script.
   In the Redwood Interface

   1. On the Applications page, open the application and then open the database (cube).
   2. Click Scripts and click Calculation Scripts.
   3. Select the script for which you want to assign access, and click the Roles tab.

   In the Classic Web Interface

   1. On the Applications page, expand an application, and select a cube.
   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. Select a script and select the Roles tab.
3. Add the users or groups to assign them access and save your changes. The users or groups are given permission to execute the specific calculation script.

See also: Create Calculation Scripts

Work with Files and Artifacts