Chapter 7. Designing Aggregations and Hierarchies
After completing this chapter, you will be able to:
Use the Aggregation Design Wizard to design aggregations.
Create user hierarchies and attribute relationships for dimensions.
Control aggregation levels for individual dimensions.
Create aggregations that optimize actual usage patterns.
In the previous three chapters, you designed the measures and dimensions for a cube. Now it’s time to consider how to optimize that design by creating aggregations and user hierarchies. In this chapter, you’ll learn how to build aggregations that improve query performance without excessively increasing the disk space required to store cube data. In addition, you’ll learn how to create user hierarchies that not only ...
Get Microsoft® SQL Server™ 2005 Analysis Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
