March 2011 - Posts

• Great post from Jeffrey Wang about DAX

  In case you missed it, this post from Jeffrey about DAX and the way filter contexts work is simply awesome! The way he explains the filter contexts internals is great, deep technical and yet easy to understand. Very very strongly suggested as a good reading Read More... Posted Wednesday, March 23, 2011 8:54 PM by AlbertoFerrari | 0 Comments

• Visio Forward Engineer is on Codeplex

  As you might already know I have written an add-in for Microsoft Visio 2010 which makes it able to forward engineer database diagrams to SQL Server. A huge number of people downloaded it and started asking for some new features, as it is always the case Read More... Posted Wednesday, March 23, 2011 7:15 PM by AlbertoFerrari | 0 Comments

• Thinking in DAX: Counting Products in the Current Status with PowerPivot

  One of my readers came to me with an interesting formula to compute in PowerPivot. Even if I don’t normally post about very specific scenarios, I think this time it is interesting to write a blog post since the formula can be easily created, if you think Read More... Posted Tuesday, March 08, 2011 9:00 AM by AlbertoFerrari | 3 Comments Filed under: PowerPivot

• PowerPivot, Parent/Child and Unary Operators

  Following my last post about parent/child hierarchies in PowerPivot, I worked a bit more to implement a very useful feature of Parent/Child hierarchies in SSAS which is obviously missing in PowerPivot, i.e. unary operators. A unary operator is simply Read More... Posted Tuesday, March 01, 2011 9:00 AM by AlbertoFerrari | 3 Comments Filed under: PowerPivot, Parent/Child