THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

Analyze #DAX query plan with Profiler

Jeffrey Wang started the 2012 (or finished the 2011, depending on your time zone) by publishing the first article dedicated to DAX Query plan. While I look forward to reading next articles, it is interesting the explanation of what is the relationship between MDX and DAX in Analysis Services 2012.

An MDX query sent to a Tabular model is not converted in an equivalent DAX query, but at a certain point a DAX query plan is created (and probably many of them, both logical and physical plans). This is something that is very clear whenever you compare the DAX Query plan obtained from an MDX query and the one generated by an equivalent DAX query (You can find more examples in my article about converting queries from MDX to DAX).

Happy 2012 to everyone!

Published Sunday, January 1, 2012 9:17 AM by Marco Russo (SQLBI)
Filed under: ,


No Comments
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement