February 2011 - Posts

• Attribute Overwriting in MDX

  Jeffrey Wang wrote a great blog post about attribute overwriting in MDX that is very clear and full of helpful pictures to show what happens when you write an MDX statement that writes into your multidimensional space. This is very common in an MDX Script Read More... Posted Thursday, February 24, 2011 5:10 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, MDX

• Microsoft BI Conference in Portugal

  If you are in Portugal or you are looking for a very good reason to visit Lisbon, don’t miss the sessions about PowerPivot that Alberto Ferrari will present at the Microsoft BI Conference in Lisbon on March 25, 2011. The conference is free and Alberto Read More... Posted Thursday, February 24, 2011 3:12 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Conference, PowerPivot

• New PowerPivot Workshop dates: Copenhagen, Dublin and Zurich

  The PowerPivot Workshop roadshow will continue in Europe in March and April. Registrations are now open for the following new dates in Denmark, Ireland and Switzerland: Copenhagen : 21-22, March 2011 at the Radisson Blu Royal Hotel Dublin : 28-29, March Read More... Posted Tuesday, February 15, 2011 10:38 AM by Marco Russo (SQLBI) | 0 Comments Filed under: PowePivot, PowerPivot

• SQLBits Training Day with SQLBI Methodology

  You might already know that I and Alberto Ferrari will present the SQLBI Methodology in a Training Day at SQLBits 8 . What you might need to know is that registrations are very good and there are not so many seats available. I don’t know whether it will Read More... Posted Monday, February 14, 2011 12:20 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Conference, Methodology

• Last week to register for PowerPivot Workshop in Frankfurt

  Flash news about PowerPivot Workshop : this is the last week to register for the Frankfurt date (21-22 February 2011). We are going to announce the next dates in Europe in March/April 2011: Copenhagen (Denmark), Dublin (Ireland) and Zurich (Switzerland). Read More... Posted Monday, February 14, 2011 2:37 AM by Marco Russo (SQLBI) | 0 Comments Filed under: PowePivot

• Slowly Changing Dimensions handling in PowerPivot (and BISM?)

  During the PowerPivot Workshop in London we received many interesting questions and Alberto had the inspiration to write this nice post about Slowly Changing Dimensions handling in PowerPivot. It is interesting the consideration about SCD Type I attributes Read More... Posted Thursday, February 10, 2011 4:06 PM by Marco Russo (SQLBI) | 2 Comments Filed under: DAX, PowerPivot

• PowerPivot FILTER condition optimizations

  In the comments of a recent post from Alberto Ferrari there was an interesting note about different performance related to the order of conditions in a FILTER call. I investigated about that and Jeffrey Wang has been so nice to give me some info about Read More... Posted Monday, February 07, 2011 4:10 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, PowerPivot

• Parameterize Charts using Excel Slicers in PowerPivot

  One new nice feature of Excel 2010 is the Slicer. Usually, slicers are used to filter data in a PivotTable. But they might be also useful to parameterize an algorithm or a chart! We discussed this technique in our book , but Alberto Ferrari wrote a post Read More... Posted Thursday, February 03, 2011 1:18 AM by Marco Russo (SQLBI) | 1 Comments Filed under: Excel, PowerPivot