THE SQL Server Blog Spot on the Web

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

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
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: , , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

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

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement