Save, Execute, and Copy Calculation Scripts

You can create and save calculation scripts in the Essbase web interface or REST API. You can also migrate or upload calculation scripts, run them as jobs, and reuse them for other cubes (databases).

Save Calculation Scripts

You save an Essbase calculation script as an artifact associated with the cube (database) that you plan to calculate. If a calculation script is intended to be executed on multiple cubes, you must upload the calculation script to each one.

If a calculation script is created in a text file and saved on a client computer, you can paste the script into the editor on the Scripts page in the Essbase web interface and then save the script, or you can upload the calculation script file to Essbase.

See Also

Create Calculation Scripts

Work with Files and Artifacts

Execute Calculation Scripts

There are multiple ways to run Essbase calculation scripts: from Essbase web interface, or the command line (CLI), MaxL, API, or Smart View.

Before you can execute a calculation script, whether you use the Essbase web interface, the REST API Execute Jobs endpoint or any other method, the calculation script must be saved as an artifact for the cube that you plan to calculate. When you run the job type to execute the calculation, the job runs in the background. You can see the status of the calculation. See Execute Calculations if you primarily use the Essbase web interface.

To execute a calculation script in Smart View, see Calculating Data in the Working with Oracle Smart View for Office.

You can also use the execute calculation MaxL statement or the CLI calc command to run Essbase calcs.

Copy Calculation Scripts

You can copy calculation scripts to applications and cubes (databases) on any Essbase Server, according to your permissions. You can also copy scripts across servers as part of application migration.

To copy a calculation script, you can also use the create calculation as MaxL statement or the Copy Calc Script REST API endpoint.