July 2011 - Posts

• PowerPivot Workshop in Portugal #PowerPivot, #ppws

  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... Posted Thursday, July 28, 2011 4:45 PM by AlbertoFerrari | 0 Comments

• OT: New transaction in the World Database

  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... Posted Thursday, July 21, 2011 12:17 AM by AlbertoFerrari | 9 Comments

• Tabular Parent/Child Dimensions: SumOfLeaves and the CALCULATE wall

  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... Posted Wednesday, July 20, 2011 12:05 AM by AlbertoFerrari | 7 Comments

• Parent/Child Hierarchies in Tabular with Denali

  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... Posted Tuesday, July 19, 2011 1:15 AM by AlbertoFerrari | 21 Comments Filed under: PowerPivot