O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix CDMX Queries for PowerPivot

You may have SSAS data mining structures and data mining models. You normally query these objects using Data Mining eXtensions (DMX), perhaps from SQL Server Management Studio (SSMS) or from SQL Server Reporting Services (SSRS). Although this release of PowerPivot supports the graphical design of SQL and MDX queries, it does not support the graphical design of DMX queries. You can, however, write your own DMX. You do so by connecting to an SSAS source and entering the DMX into the MDX Statement area of the Specify a MDX Query dialog, in the Table Import Wizard. Another way is to embed your DMX query within a SQL query and import the data returned from the outer SQL query. To do that, you connect to a SQL Server ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required