PASS Community Summit 2008: Program Sessions (Business Intelligence)

Designing effective and optimized dimensions in SSAS requires knowledge of your reporting and analysis requirements as well as an understanding of various dimension design options and alternatives, dimension and attribute properties, and attribute relationships for hierarchies and aggregations. In this session, we'll discuss all of these topics to gain a better understanding of how to optimize your dimension designs within SSAS. We'll look at several design scenarios along with various alternatives for creating and dealing with different types of dimensions. We'll discuss dimension design differences between SSAS 2005 and SSAS 2008 and how to take optimize your dimension designs in each environment. Finally, we'll discuss common dimension performance and design issues, offering thoughts on how to overcome these issues (or at least understand the workarounds and options).

Register Now for PASS Community Summit 2008!