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.
Slide Deck 261 KB