The MDX graphical query designer has two modes: design mode and query mode. Each mode provides a metadata pane from which you can drag members from the selected cubes to build an MDX query that retrieves data when the report is processed.. GeoPITS brings you the comprehensive details of MDX edit, debug, and design tools's support in different versions & editions of SQL Server.
Version | Enterprise | Standard | Web | Express (Adv.) | Express |
---|---|---|---|---|---|
Version v2019 | Yes | Yes | |||
Version v2017 | Yes | Yes | |||
Version v2016 | Yes | Yes | |||
Version v2014 | |||||
Version v2012 |
The MDX graphical query designer has two modes: design mode and query mode. Each mode provides a metadata pane from which you can drag members from the selected cubes to build an MDX query that retrieves data when the report is processed.
You can find more details about this version here