It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

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.

Chris Webb is an independent consultant specialising in Analysis Services, MDX, PowerPivot and DAX. 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 http://cwebbbi.wordpress.com/