Use Calculation Script Editor to create calculation scripts that specify how Essbase calculates a database. Use Report Script Editor to create report scripts that contain instructions for data retrieval, formatting, and output.
When you create a script, you can associate it with one database or with all databases of one application.
To create calculation or report scripts:
From Enterprise View or a custom view, select the application or database with which you want to associate the script.
Select File, and then New to open the New dialog box.
Select the Scripts tab, select Calculation script or Report script, and click OK.
A blank script opens in the appropriate editor.
If the outline tree is not populated, associate an outline with the script.
If you select a database from Enterprise View before you open the New dialog box, the script is automatically associated with the selected database, and the outline tree is populated.
Compose the script, and check script syntax.
create calculation (MaxL) in the Oracle Essbase Technical Reference