Saving, Executing, and Copying Calculation Scripts

You can create and save calculation scripts in the Essbase web interface. You can also upload calculation scripts, run them as jobs, and reuse them for other databases.

Saving Calculation Scripts

You save a calculation script as an artifact for the database that you plan to calculate. If a calculation script is intended to be executed on multiple databases, you must upload the calculation script to each database.

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 Create Calculation Scripts and Work with Files and Artifacts.

Executing Calculation Scripts

Before you can execute a calculation script in the Essbase web interface, the calculation script must be saved as an artifact for the database 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.

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

To execute a calculation script, you can also use the execute calculation MaxL statement.

Copying Calculation Scripts

You can copy a calculation script to any Essbase database. See Uploading Files to a Cube.

To copy a calculation script, you can also use the create calculation as MaxL statement.