MDX is becoming more and more important in the IBM Planning Analytics / TM1 community and it is one of the key skills that any TM1 developer needs to have.
Arc includes a dedicated feature for editing and working with MDX queries called the MDX Lab. Here are several innovative features it introduces.
A Fully Customisable Code Formatter for MDX
Arc supports code formatting for Processes, Rules, and MDX. Copy any MDX query, click Format Code, and your query is formatted with the correct case and spaces. You can fully customise this by adding your own best practices:
Run a Selected Part of the MDX Query
Troubleshooting a long MDX query can be cumbersome. With the MDX Lab, select a part of the query and click Execute to run just that section:
Autocomplete your Query with the Full List of MDX Functions
Press Ctrl+Space to scroll through all MDX functions in a drop-down menu:
Gain Access to Many MDX Snippets
Inside the functions list, use the @ symbol to show only snippets. For example, use @Hierarchy Filter by Level to get elements filtered by level: