Specifying Options for Optimizing Storage

The reason to add an OLAP layer to a data warehouse is to make data retrieval flexible and fast. As you learned in Chapter 1, the cube structure, with a hierarchy defined in each dimension, makes interacting with the cube flexible because you can drill up and down the hierarchies and slice or dice by dimension members. To make the data retrievals fast, Analysis Services summarizes selected values and stores them as predefined aggregations. You define aggregations in a cube, by first specifying the appropriate storage modes for the cube.

Understand Analysis Server Storage Modes

As you learned in Chapter 2, an Analysis Services cube consists of three logical components: a map, detail values, and aggregated ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.