Fun with Scoped Assignments in MDX

Scoped assignments are one of the most powerful features in MDX, but also one of the most difficult to understand. This session will introduce the concept of scoped assignments, how they can be created and what kinds of calculations can be implemented using them. Some previous knowledge of MDX will be assumed.
Presented by Chris Webb at SQLBits VIII
  • Downloads
  • SpeakerBIO
    Chris Webb is an independent consultant specialising in Analysis Services, MDX, Power BI, Power Pivot and Power Query. He is the author of "Power Query for Power BI and Excel" and a co-author of "SQL Server Analysis Services 2012: The BISM Tabular Model", "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase". He blogs at
  • Video