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

These are the last days to register for the PowerPivot Workshop in Zurich on April 4-5, 2011. If you are willing to attend, hurry up!Moreover, on Thursday evening there will be also a Swiss PASS Chapter meeting in Zurich and…  Read more

The next Monday, March 21st, I will join a special event organized by the Danish SQL Server User Group, Excelbi.dk and the Swedish SQL Server User Group. The meeting will start at 18:00 at the Radisson Royal Blu in Copenhagen,…  Read more

As many of you probably already know, Donald Farmer left Microsoft to join QlikView. There is no doubt that Donald has been “the face of Microsoft BI” in the last few years. This news has been initially perceived (me included,…  Read more

In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago.  Read more