“Using MaxL Data Definition Language” in the Oracle Essbase Database Administrator's Guide
MaxL DDL Statements
MaxL is the multidimensional database definition language (DDL) for Essbase Server. Using MaxL, you can easily automate administrative and query operations on Essbase Server.
A MaxL script contains a login statement and a sequence of MaxL statements, each terminated by a semicolon. If you use MaxL Script Editor to execute a MaxL script, the login statement is optional; you can select the Essbase Server that you want to connect to from the editor. Most MaxL statements begin with a verb and consist of grammatical sequences of keywords and variables. MaxL Script Editor color-codes the elements of the MaxL syntax and provides an auto-complete feature that helps you build statements as you type. For detailed information about MaxL syntax, see the MaxL section in the Oracle Essbase Technical Reference.
You can write MaxL scripts in MaxL Script Editor or in an external text editor. You can open existing scripts and modify or execute them from MaxL Script Editor. You cannot save MaxL scripts as Essbase objects on Essbase Server; therefore, MaxL scripts are not displayed in Enterprise View. You can, however, enable other users to access MaxL scripts by saving them to the middle-tier Essbase Administration Server. You can also save MaxL scripts as text files on a client computer or on a network, and you can open and manage the files in MaxL Script Editor. See Saving MaxL and MDX Scripts for instructions.
You do not have to save MaxL scripts in order to execute MaxL statements. You can interactively type, execute, and clear MaxL statements from within the editor to perform one or more operations at a time.