During TechEd 2011, Microsoft announced an important update to its BI roadmap . The reason why this is important is related to the previous announcement, which I discussed in November 2010 by including links to several sources and comments. At PASS Summit  Read more

In the last months I talked mostly about PowerPivot, but Analysis Services is still growing and a very good sign of that is the number of downloads of The Many-to-Many Revolution whitepaper, who has been published almost 5 years ago and recently surpassed  Read more

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  Read more

Chris Webb posted a wonderful solution to the Last “ever” non empty calculation in MDX . I never thought to this solution and it is really a nice approach. I think that DAX might be faster in this scenario – a similar calculation has been shown in this  Read more

Last week Alberto published an interesting post about Counting Products in the Current Status with PowerPivot . Starting from a question raised from a reader, Alberto described how to solve a common issue (let me know the “current status” of each item  Read more

The early bird discount for the PowerPivot Workshop in Dublin will expire today, Friday 11 March. There is also an upcoming workshop in Copenhagen (March 21-22, 2011) and a PowerPivot workshop in Zurich on April 4-5, 2011. I and Alberto are preparing  Read more

I recently got a question about differences between DISTINCT and VALUES in DAX and thanks to Jeffrey Wang I created a simple example to describe the difference. Consider the two tables below: Fact and Dim tables, having a single column with the same name  Read more

Alberto wrote an excellent post describing how to implement the Unary Operator feature (which is present in Analysis Services) in PowerPivot (there was a previous post about parent-child hierarchies, too). I have to say that the solution is not so easy  Read more

Jeffrey Wang wrote a great blog post about attribute overwriting in MDX that is very clear and full of helpful pictures to show what happens when you write an MDX statement that writes into your multidimensional space. This is very common in an MDX Script  Read more

During the PowerPivot Workshop in London we received many interesting questions and Alberto had the inspiration to write this nice post about Slowly Changing Dimensions handling in PowerPivot. It is interesting the consideration about SCD Type I attributes  Read more