Data modeling in Tabular is different from Multidimensional. I spend much time teaching people that they need to change their mind when approaching the Vertipaq engine, because it is a different tool with different capabilities. Nevertheless, I still  Read more

This year I and Marco Russo will host a Birds of a Feather lunch about “ DAX, Vertipaq and BISM Tabular ” during PASS Summit in Seattle. If you want to spend some time speaking about DAX, the new Vertipaq engine of just have a good chat in front of some  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 I could  Read more

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 of SSAS and Marco Russo who  Read more

September 29th I and Marco Russo will be delivering a full day of deep dive into the DAX programming language, during the training days of SqlBits 9 . Later on, during the conference, I will deliver a session about many to many relationships in DAX, exploiting  Read more

Tomorrow, at 11 AM CET, I will deliver a webinar on how to produce interesting reports with PowerPivot, a webcast which is a first taste of my incoming session for the European Sharepoint Conference. You can see all the details here: http://www.sharepointeurope.com/upcoming-webinars/self-service-bi-at-work,-an-example-of-a-powerful-user-created-report-in-powerpivot.aspx  Read more

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 CTP3 of PowerPivot  Read more

Wow! Today I hit F5 on this interesting transaction: BEGIN TRANSACTION     INSERT INTO World.Babies (Name, Surname, DateOfBirth, Gender)     VALUES (‘Arianna’, ‘Ferrari’, ‘20110720’, ‘Female’);     UPDATE World.Parents  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 that post. I am not  Read more

Some time ago, I wrote a post about how to handle Parent/Child hierarchies in PowerPivot 1.0. It was pretty intricate, because P/C are not handled natively in PowerPivot. Now, with the advent of Denali, Microsoft gave us all the functions needed to handle  Read more