Chapter 8. Storage Optimization

Chapter Objectives Estimated time: 1.75 hours
In this chapter, you’ll learn when to use each of the three data storage modes, how aggregations work, and how to

  • Use the Storage Design Wizard to set storage mode and design aggregations.

  • Create aggregations that optimize actual usage patterns.

  • Control aggregation levels for individual dimensions.

As you learned in Chapter 1, “A Data Analysis Foundation,” an OLAP cube appears to contain every possible summarized value at every possible level of detail for every dimension. For example, the Sales cube created in Chapter 2, “Analysis Manager from 500 Feet,” contains Sales Units and Sales Dollars as measures and Product, Employee, State, and Time as dimensions. If you query ...

Get Microsoft® SQL Server™ 2000 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.

Start your free trial