17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

Performance Tuning MDX queries

You've built your cube and it's working well, but there's one important query which is taking hours to run. How can you tune it? This session will tell you how to diagnose the causes of poor query performance with Analysis Services 2005 and share some hints and tips on how to solve them by optimising your cube structure and writing efficient MDX.
Presented by Chris Webb at SQLBits I
  • Downloads
    Slide deck available Slide Deck 261 KB
  • SpeakerBIO
    Chris_Webb.jpg
    Chris Webb is an independent consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is 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", and blogs at http://cwebbbi.wordpress.com/ 
    http://cwebbbi.wordpress.com/ http://feeds.feedburner.com/wordpress/Cpjz
  • Video
  • Session Files Explorer
    The network name cannot be found.