Execute Calculations

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

Create your calculation script, or upload an existing calculation script.
Navigate to a script,
- In the Redwood Interface
  1. On the Home page, click Files.
  2. Double click the application name and then double click the cube name.
  3. Click the script name, and the script is opened in the calc script editor.
- 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.
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:

Ensure that you are logged into the Essbase web interface as a service administrator or power user.
Navigate to the Roles tab for your calculation script.
In the Redwood Interface
1. On the Home 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.
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.