A new date is available for the PowerPivot workshop I and Marco are delivering all over Europe. On September 19-20, 2011 we will be in Lisbon (Portugal) to present the workshop to Excel users and BI professionals. Moreover, as Denali…  Read more

In my last post about Parent/Child hierarchies, there is a question, in the comments, that I found interesting. Nevertheless, the formula is a complex one and cannot be written in a simple comment. Thus, I am making a follow-up to…  Read more

Alberto Ferrari published an interesting blog post regarding how to write particular calculations over a parent-child hierarchy in PowerPivot Denali (and in BISM Tabular, of course). One case is the Sum of Leaves (summing only the leaves of a parent-child…  Read more

If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, you cannot import the attribute key value. Only the attribute name is included in…  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

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

article

KEEPFILTERS: a new DAX feature to correctly compute over arbitrary shaped sets

Having read this question on the mdsn blogs, I investigated on the KEEPFILTERS function and, after having learned it, it is now time to write about it. Moreover, before start to write about it, I need to thank the dev team…  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

We presented a few session at SQLBits and the video of these sessions are available. This is the list of sessions available from SQLBits 8 and SQLBits 9 – just click the link on the title and jump to the…  Read more