Saving MaxL and MDX Scripts

You cannot save MaxL scripts and MDX scripts as Essbase objects on Essbase Server; therefore, these scripts are not displayed in Enterprise View. You can, however, enable other users to access a MaxL or MDX script by saving the script to the middle-tier Essbase Administration Server. You can also save MaxL and MDX scripts as text files on a client computer or on a network, and you can open and manage the files in the appropriate script editor.

You do not have to save a script in order to execute statements in the editor.

If you want to save the results of a MaxL script, see Saving MaxL and MDX Results.

  To save a MaxL script or an MDX script:

  1. Create or open the script.

  2. Select File, then Save script.

  3. Perform an action:

    • To save the script as an object on Essbase Administration Server:

    1. In Save As, select Essbase Administration Server.

    2. In Name, enter a name for the script.

      MaxL scripts are given an .mxl extension by default.

      MDX scripts are given an .mdx extension by default.

    3. Optional: To allow other users to open, edit, and save the script, select Shared.

    4. Optional: To specify UTF-8 encoding, select UTF-8.

    5. Click OK.

    • To save the script locally or on a network:

    1. In Save As, select File System.

    2. Navigate to the drive and folder where you want to save the script.

    3. In File name, enter a name for the script.

      MaxL scripts are given an .mxl extension by default.

      MDX scripts are given an .mdx extension by default.  

    4. Optional: To specify UTF-8 encoding, select UTF-8.

    5. Click OK.

Related Information