Event: Best Practice in Analysis Server and MDX

Grant Paisley - Tuesday, June 05, 2007
Microsoft SQL Server 2005 Analysis Services includes a complete re-architecture of the Online Analytical Processing (OLAP) engine from Microsoft SQL Server 2000.

In this session we will focus on the performance and scalability aspects of the Analysis Services architecture and cover cube design, providing specific guidance on how to design for optimal performance, and also cover MDX and calculations.

Cube design and storage

We will discuss cube modeling (emphasizing the importance of attribute relationships), partitioning strategies, aggregation management and cube processing. For each of these, we will explain the important design principles, and provide best practices for performance and scalability.

MDX and calculations

We take common business problems and show how MDX can be utilized to solve them while keeping query performance under control. Finally we point out common gotchas for poor performance in MDX and best practices to address them.

These principles and practices should be a necessary foundation for any organization embarking on a large-scale business intelligence project based on Analysis Services 2005.

We will make *you* the BI hero!

For more information seeĀ http://www.sqlserver.org.au/Events/ViewEvent.aspx?EventId=264