The SQL Server Profiler provides you many information regarding the internal behavior of DAX queries sent to a BISM Tabular model. Similar to MDX, also in DAX there is a Formula Engine (FE) and a Storage Engine (SE). The SE is usually handled by Vertipaq  Read more

I just installed a brand new server (well, a virtual machine) with SharePoint 2010 SP1 and SQL Server 2012 RC0, including PowerPivot and Reporting Services / Power View. The server is joined to the domain I use in our development environment. I published  Read more

I started learning MDX in 1999 and after so many years of using it and teaching it to other people, I still discover something new every day. Not only because I use it in strange ways (well, this doesn’t happen every day, at least!) but because there  Read more

In September 2006 I had announced in this blog the release of the first version of The Many-to-Many Revolution, a whitepaper that describes how to leverage the many-to-many dimension relationships feature that had being available since Analysis Services  Read more

I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write queries in both DAX and MDX. If you already  Read more

Last week Microsoft announced a new licensing schema for SQL Server 2012. If you are interested in an extensive discussion of the new licensing scheme, Denny Cherry wrote a great blog post about that. I’d like to comment about the new BI Edition license.  Read more

As you may have noted, I started using hashtag in titles of my blog posts. The reason is pretty simple: every post is automatically twitted through my account ( @marcorus ) and in this way they can be easily reached also by people monitoring particular  Read more

If you are looking to create many-to-many relationships based models in PowerPivot and in BISM Tabular, probably one day you will be interested in using them with Power View (formerly codename “Crescent”). There is a very bad news for you: it appears  Read more

I’ve been at SQL Pass and it has been a really great conference. I will write soon more technical content, there are a few notes about the good and the bad of the overall experience that I’d like to share. The keynote of David J. Dewitt has been great.  Read more

Thomas Kejser and Denny Lee released the new Analysis Services 2008 R2 Performance Guide . This is an absolutely must read for any SSAS developer. Remember that many of the optimizations are obtained by doing a proper cube design. Thus, the paper has  Read more