August 2011 - Posts

• I will speak at #SQLPass #Summit and #SQLRally Nordic!

  I already announced a few weeks ago that I and Alberto will speak at SQLBits in Liverpool. We will also speak at SQLPASS Summit in Seattle and at SQLRally Nordic . A few details about my sessions: SQLPASS Summit (Seattle, WA – October 11-14, 2011) : My Read More... Posted Tuesday, August 30, 2011 11:34 AM by Marco Russo (SQLBI) | 0 Comments Filed under: BISM, Conference, PASS

• #MDX Cookbook : a new must read for #SSAS developers

  There are not so many books about MDX and it’s strange considering that it is a very sophisticated languages that requires years for learning (I’m not kidding). I started learning MDX in 1999 and after so many years, I still have to learn something. I’ve Read More... Posted Thursday, August 25, 2011 12:21 PM by Marco Russo (SQLBI) | 9 Comments Filed under: Book, MDX, SSAS

• Importing tables from #BISM Tabular model in #PowerPivot

  A BISM Tabular model can be browsed in Excel by using just the standard PivotTable like it was a regular Analysis Services cube (that now we call a Multidimensional model). If you are used to PowerPivot, this seems a limitation, because you cannot interact Read More... Posted Friday, August 19, 2011 3:33 PM by Marco Russo (SQLBI) | 10 Comments Filed under: BISM, SSAS

• Drillthrough for #BISM Tabular and attribute keys in #SSAS #Denali

  In an Analysis Services cube you can define drillthrough actions on a cube. This feature has been working since SQL 2005 and now it will be available in both BISM Multidimensional and BISM Tabular in the next version of SQL Server “Denali”. In the current Read More... Posted Thursday, August 18, 2011 12:18 AM by Marco Russo (SQLBI) | 1 Comments Filed under: BISM, Denali, SSAS

• #BISM, Measures and a new blog from a #ssas development team member

  In the PowerPivot book and in the PowerPivot Workshop I mentioned the difference between implicit and explicit measures. The use of implicit measures might be confusing because at the end they are automatically created and maintained by the user interface Read More... Posted Tuesday, August 16, 2011 12:04 PM by Marco Russo (SQLBI) | 0 Comments Filed under: BISM, DAX, PowePivot

• A #DAX training day and other sessions at #SQLBits

  It seems that the next SQLBits will be larger than ever! The SQLBits 9 will take place in Liverpool from 29th September to 1st October 2011. It will be hard to get a nicer weather than in Brighton, but we will try to bring a bit of sun from Italy! I and Read More... Posted Thursday, August 11, 2011 1:10 PM by Marco Russo (SQLBI) | 0 Comments Filed under: BISM, Conference, DAX, SSAS

• Workaround for lack of PowerPivot API in Excel

  A few days ago a post about VSTO-based PowerPivot Workbook in the PowerPivot Team Blog shown a workaround for the lack of PowerPivot API in Excel. In reality, I don’t like this workaround at all, because it relies on displaying message boxes to the end Read More... Posted Monday, August 08, 2011 5:22 PM by Marco Russo (SQLBI) | 23 Comments Filed under: Excel, PowerPivot