Edit sets using the MDX editor

The MDX editor is available in the IBM® Planning Analytics Workspace books and modelling workbench.

Note: The new MDX editor is not currently available in IBM Planning Analytics for Microsoft Excel.

The MDX editor allows you to make changes to the MXD expressions in a view.

To access the MDX editor, click the Edit MDX icon MDX editor cion.

The following features are available in the MDX editor:
  • Autocomplete: provides suggestions on dimension names, functions, and other TM1 objects while you are typing.
  • Syntax coloring: shows different portions of the MDX statement in different colors for increased readability. For example, keywords are written in red, and tuples are written in blue.
  • Undo: allows you to undo the last change.
  • Redo: allows you to redo the last change.
  • Find and replace: clicking ctrl+f open a dialogs that allows you to search for specific text in the MDX, and replace it.
  • Indenting: the MDX editor now automatically formats the MDX script, indenting each line. When you make changes in the view, the MDX editor updates with the correct formatting. You can manually indent the lines in the script by clicking Indent script MDX editor indent icon in the MDX editor toolbar.

  • Commit applies your MDX edits to the view. When you click Commit, a text box appears telling you if the changes were made successfully.

  • Synchronize replaces the MDX in the editor with the one represented in the view. After you click Synchronize, clickOK to synchronize.

    Note: When you make edits in a view, the MDX editor automatically synchronizes to match these changes. However, when you make edits in the MDX editor, the view does not automatically synchronize to match these changes. You have to manually select where you want your edits to apply using the Commit MDX editor commit icon and Synchronize MDX editor synchronize icon buttons in the MDX editor toolbar.