You can save calculation and report scripts as Essbase objects on Essbase Server or as text files on a network or client computer.
Scripts saved as Essbase objects are associated with an Essbase application or database. Only scripts that are saved as Essbase objects are displayed in Enterprise View. Scripts saved as Essbase objects are saved on the Essbase Server as follows:
ARBORPATH\app\appname\scriptname.csc
or ARBORPATH\app\appname\dbname\scriptname.rpt
Scripts not saved to the Essbase Server directory structure are not saved as Essbase objects. If you want to work on a script locally, save it on your client machine or on a network.
To save scripts to Essbase Server:
Select File, and then Save as.
In the Save As dialog box, select the Essbase Server tab.
In Look in, select the Essbase Server on which you want to save the script.
Navigate to the application or database where you want to save the script.
In File name, enter a name for the script.
See the Oracle Essbase Database Administrator's Guide for file name length limitations.
By default, calculation scripts use a .csc extension, and report scripts use a .rep extension. Only scripts with the default extensions can be viewed or executed from Administration Services Console.
Click OK.
Essbase saves the script and updates Enterprise View.
To save scripts locally or on a network:
In the Save As dialog box, select the File System tab.
Navigate to the file-system directory where you want to save the script.
In File name, enter a name for the script.
By default, calculation scripts use a .csc extension, and report scripts use a .rep extension. Only scripts with the default extensions can be viewed or executed from Administration Services Console.
If you are prompted for encoding, perform an action:
For Unicode-encoding, select UTF-8.
For non-Unicode encoding, accept the default selection.
Click OK.
Essbase saves the script in the specified location.