Recommended Practices for Analysis Services 2005/2008 Design
Although Analysis Services 2005 and 2008 have been available for some time, performance tuning and troubleshooting documentation is still sparse. Database administration expert Baya Dewald offers recommendations for avoiding the most commonly encountered dimension/partition design pitfalls.
Microsoft’s SQL Server Analysis Services (MSAS) 2005 was a revolutionary release that dramatically changed how software developers and database administrators build and manage business intelligence (BI) solutions. A huge number of new features and changes introduced with this release instigated a steep learning curve even for those IT professionals who felt comfortable building cubes with previous releases of software.
Tags: design, performance