When you copy a calculation or report script, Essbase copies the script to the application or database directory on the destination Essbase Server. To copy such scripts, you can use the method described in this topic or the file system.
You can also copy scripts across servers as part of application migration. See Migration Wizard.
To copy scripts to new locations:
From Enterprise View or a custom view, select a script.
Right-click, and select Copy.
Essbase displays the Copy Calculation Script dialog box or the Copy Report Script dialog box.
Select the name of the Essbase Server that contains the application and database to which you want to copy the script.
In Application name, select the application with which you want to associate the script.
Perform an action:
To associate the script with one database, in Database name, select the database.
To associate the script with all databases of the selected application, select (all dbs).
In Calculation script name or Report script name, enter a new name for the script.
Click OK.
If Administration Services asks whether you want to overwrite the existing script, click Yes.
Essbase copies the script and updates Enterprise View.
alter object (MaxL) in the Oracle Essbase Technical Reference
create calculation as (MaxL) in the Oracle Essbase Technical Reference
copyobject (ESSCMD) in the Oracle Essbase Technical Reference