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 ...