To open MaxL Script Editor, from the console menu bar, select File, then Editors, and then MaxL Script Editor.
To open an existing MaxL script, see Opening MaxL and MDX Scripts.
MaxL Script Editor features a text editing window, customized menus, a toolbar, a shortcut menu, color-coding and auto-completion of MaxL syntax, and an output pane. You can customize the editor to suit your preferences.
You can open existing MaxL scripts in MaxL Script Editor. MaxL scripts can have any naming format. However, to be opened in MaxL Script Editor, scripts must have an .mxl or .msh extension. The default extension given to scripts created and saved in MaxL Script Editor is .mxl. To use a file that does not have an .mxl or .msh extension (for example, a .txt file), reference the file.
You need not modify existing scripts to open and execute them from MaxL Script Editor. The editor understands MaxL Shell syntax, such as the login, logout, spool, and echo commands. The following MaxL Shell commands are incorporated into the functionality of the editor itself and therefore are ignored during script execution: set, shell, version, and exit.
For information about how connections to Essbase Servers are handled and for information about using the login and logout commands, see Connecting to Essbase Servers in MaxL and MDX Script Editors.
Within MaxL Script Editor, you can perform the following MaxL-related tasks:
Create, edit, save, and execute MaxL scripts to automate Essbase administration tasks.
Type, execute, and clear MaxL statements interactively to perform one or more Essbase operations at a time.
Use auto-completion to help you build MaxL statements quickly.
Customize color-coding that is used to highlight syntax elements.
Reference files to execute with a script.
Expand scripts to display variable values and the contents of referenced files.
“Using MaxL Data Definition Language” in the Oracle Essbase Database Administrator's Guide
MaxL DDL Statements