To open MDX Script Editor, from the console menu bar, select File, then Editors, and then MDX Script Editor.
MDX Script Editor features a text editing window, customized menus, a toolbar, a comprehensive right-click menu, color-coding and auto-completion of MDX syntax, and an output pane. You can customize the editor to suit your preferences.
MDX scripts can have any naming format. However, for an MDX script to be opened in MDX Script Editor, it must have an .mdx extension. You do not need to modify existing scripts in order to open and execute them from MDX Script Editor. The default extension given to scripts created and saved in MDX Script Editor is .mdx.
Within MDX Script Editor, you can perform the following tasks:
Create, edit, save, and execute MDX scripts to automate Essbase administration tasks.
Type, execute, and clear MDX statements interactively to perform one or more operations at a time.
Use auto-completion to help you build MDX statements quickly.
Use the outline and function trees to insert members and functions in the script without having to type them manually.
Customize color-coding that is used to highlight syntax elements.
Expand scripts to display variable values.
“Writing MDX Queries” in the Oracle Essbase Database Administrator's Guide
MDX Functions