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.
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/
The video is not available to view online.