Execute Calculations

After creating and saving calculation scripts, you use the Jobs page to execute them and perform the calculations on data loaded in your cube.

Create your calculation script, or upload an existing calculation script.
In Essbase, click Jobs.
On the Jobs page, click New Job and select Run Calculation.
On the Run Calculation dialog box, select the application and cube you want to calculate.
Select the script you want to use.
Click OK to start the calculation.
Click Refresh to see the status of your calculation.

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 will not execute from the server, because the point of view can only be known from a Smart View grid.

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

Assign access to execute specific calculation scripts:

Log into the Essbase web interface as a service administrator or power user.
On the Applications page, expand an application, and select a cube.
From the Actions menu, to the right of the cube name, launch the inspector.
Select the Scripts tab, and then select the Calculation Scripts tab.
Select a script and select the Permissions 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.