The Mdx Editor allows you to change the MDX query for any data visualization widget, implement desired calculations, and also to change the presentation of data in the grid.
It is a powerful tool. However, it requires knowledge of MDX and the following precautions must be taken:
- Thorough testing of scripted MDX queries.
- Verification that key GUI features (for example,auto-expand, filters, and formatting) are able to interact with all queries containing custom code.
Show Mdx Editor
- To access Mdx Editor, right-click in the data area of any data visualization widget.
- You can also add Mdx Editor from the Widgets Panel.
Please refer to the keyboard shortcuts page.
Please refer to the MDX Resources page.