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

Boyan Penev announced the availability of DateStream project on CodePlex: it is a data feed that can be consumed by PowerPivot but also to generate a calendar table for any type of usage. Yes, Analysis Services has a wizard, but when you are in a hurry  Read more

I just returned from my second SQLBits , this time in Liverpool, and I have to say it is a really great conference. Everything can be improved, but I have to say that it’s hard to find a conference where you can have more networking opportunities than  Read more

SQLCAT team just announced the first SSAS Maestros and I’m happy to be part of them! I already know many of them and I’m more than happy to see that also Alberto and Chris, who co-authered the Expert Cube Development with Microsoft SQL Server 2008 Analysis  Read more

Javier Guillén wrote several blog post about how to implement certain common calculations in PowerPivot. It is interesting to read his posts not only because of the solutions he propose, but also because he uses several techniques that can be applied  Read more