When you execute a MaxL or MDX statement or script, Essbase Administration Server connects you to the Essbase Server that you are running the statement against. If you are executing a script that includes a login statement, Essbase Administration Server connects you to the Essbase Server that is specified in the login statement. Otherwise, you select the appropriate Essbase Server from within the script editor. After the script or statement is executed, Essbase Administration Server disconnects you from the Essbase Server. If you have other open sessions on the Essbase Server, the other connections remain intact.
When you execute MaxL or MDX scripts or statements, the results are displayed in the Results pane of the script editor. All results, informational messages, error messages, and warning messages are displayed in this pane. In the Options dialog box (MaxL Script Editor tab or MDX Script Editor tab), you can specify whether results for each statement are displayed on one Results tab or on multiple tabs and whether each statement is displayed along with its results.
To execute a MaxL script or an MDX script:
From the server drop-down list on the toolbar, select the Essbase Server to execute the script against.
The list contains only Essbase Servers that are displayed in your Enterprise View. For more information about connections, see Connecting to Essbase Servers in MaxL and MDX Script Editors.
Specify how errors should be handled during execution. See Setting MaxL and MDX Execution Options.
On the Results tab, specify how you want results to be displayed. See Viewing MaxL and MDX Results.
If the script contains variables, specify how undefined variables are resolved during execution. See Resolving Undefined Variables.
To execute the entire script, right-click and select Execute.
To execute only part of the script, highlight the statement or statements that you want to execute, right-click, and select Execute.
The script executes against the specified Essbase Server, and the results are displayed in the Results pane.