Best practices for SQL Server OLAP cube design and MDX querying (SharePoint Server 2010)


Applies to: SharePoint Server 2010

When you are enabling Microsoft SQL Server 2005 or 2008 Analysis Services (SSAS) in a SharePoint Server 2010 business intelligence solution, proper cube design, efficient multidimensional expressions, and sufficient hardware resources are critical to optimal performance.

This article highlights best practices that help improve the performance of SSAS as a data source for Excel Services in Microsoft SharePoint Server 2010, PerformancePoint Services in Microsoft SharePoint Server 2010, and Visio Services in Microsoft SharePoint Server 2010. The first section lists articles that highlight Microsoft SQL Server 2008 enhancements that are specifically designed for business intelligence (BI) solutions, while the second section gives best practices that apply to SSAS 2005/2008 cube design, MDX query optimization, and more.

SQL Server 2008 enhancements for business intelligence

The following articles describe enhancements to SQL Server 2008 that relate to business intelligence.

Best practices for Analysis Services