It seems that the next SQLBits will be larger than ever! The SQLBits 9 will take place in Liverpool from 29th September to 1st October 2011. It will be hard to get a nicer weather than in Brighton, but we…  Read more

Alberto anticipated me announcing our next edition of the PowerPivot Workshop in Lisbon (Portugal) on September 19-20, 2011. The announcement has been published also on the SQLPort website in Portuguese! But remember, the workshop will be entirely in English! In…  Read more

When you install Analysis Services Denali, chances are that you create an instance for Tabular that is not the default instance for Analysis Services. When you try to create a Tabular project, you might get the following error: You cannot…  Read more

If you want to detect if a particular instance of Analysis Services “Denali” is running in Tabular or Multidimensional mode, you have several choices. In the Books On Line you can find a few instructions to detect the version by…  Read more

The Analysis Services team just posted a blog entry with a few useful links to jumpstart your experience with Tabular project in Analysis Services “Denali”. In these early days I read several messages asking for clarification about the names and…  Read more

I and Alberto Ferrari will present a DAX Deep Dive training day at SQLBits 9 in Liverpool, on September 29th. The conference will continue on September 30th and October 1st. Registrations are not yet open, but you should definitely save…  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 calculation engine…  Read more

In an Analysis Services cube you can define drillthrough actions on a cube. This feature has been working since SQL 2005 and now it will be available in both BISM Multidimensional and BISM Tabular in the next version of SQL…  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

Using Visual Studio to author SSAS Multidimensional projects, I was used to copy the project, deploy it with another name and then proceed with updates, until I was satisfied with the final result. Then, working with the two projects side-by-side…  Read more