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

Recursive calculations in MDX #ssas #mdx

Jeffrey Wang wrote a very detailed blog post about recursive calculations in MDX with Analysis Services. In these days I'm doing some comparison between DAX and MDX (well, between Vertipaq/PowerPivot and OLAP/SSAS engines) and I'm discovering that MDX calculation engine is much more smart than you might think in certain conditions. I cannot anticipate very much (also because I'm far from conclusions by now), but it's clear that the combination of bulk mode evaluation and the several types of caches that are used by the OLAP engine can perform really well. As Jeffrey shows in his post, the problem is that bulk-mode evaluation is very important and its usage is very sensitive to the way the MDX query is built. You can fix the MDX query in order to improve performance, but this might be very hard whenever the query is automatically generated by a cube browser, like Excel. In these cases, Vertipaq/PowerPivot seems to offer a more predictable response time (not always faster than OLAP, anyway!).

Now back to study, I hope we'll discuss much more about these things when Denali will be publicly available with CTP3!

Published Thursday, April 28, 2011 8:51 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