Each month the PASS Data Warehousing/Business Intelligence Virtual Chapter enlists the community to present about a relevant topic, with “All about Analysis Services” as the topic for April 2011. Today I delivered my Designing Cubes for Performance presentation (download slides here). I will post a link to the recording when it becomes available.
Two really great references that cover this subject are the downloadable Analysis Services Performance Guide and a book by members of the Analysis Services development team at Microsoft, Microsoft SQL Server 2008 Analysis Services Unleashed. If you’re still new to Analysis Services, some of the concepts and terminology might take a while to digest, so plan to read and re-read these resources many times! If that still doesn’t help, add a comment to this post with your question, and I’ll try to help you better understand how to implement best practices for cube design.