Designing Effective Aggregations in Analysis Services 2008

Building aggregations is one of the most important ways of improving query performance in Analysis Services, but simply running the Aggregation Design Wizard doesn't always result in useful aggregations being built. This session shows the steps you need to go through in order to build aggregations that are actually going to be used by the queries that you're running.
Presented by Chris Webb at SQLBits IV
  • Downloads
    Video available WMV Video 117 MB
  • 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