Mdx Editor

The Mdx Editor allows you to change the MDX query for any data visualization widget, implement desired calculations, and change the presentation of data in the grid, as well.

It is a powerful tool, however it requires knowledge of MDX and precautions:

  • Thoroughly test scripted MDX queries.
  • Some GUI features, for example, auto-expand, filters, and formatting, may not be able to interact with a query 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

Keyboard Shortcuts

Please refer to the keyboard shortcuts page.

Resources

See Microsoft's Multidimensional Expressions (MDX) Reference for an official documentation of the MDX language. In particular, the complete list of all available MDX functions.

ActiveViam offers also some basic and advanced examples of MDX queries.

← KPIMonitor List →