Multidimensional OLAP
In a BI system, the multidimensional OLAP database resides between the data storage and retrieval layer and the presentation layer. It converts the relational data warehouse data into a fully implemented dimensional model that makes it fast and flexible for creating analytical reports and data visualizations. Because different OLAP databases vary in the features they provide and their physical implementation, in this section I will introduce how Analysis Services implements a dimensional data model.
The columns containing numerical data in a fact table correspond to measures in a dimensional model, so each fact table is a group of measures. Analysis Services organizes information in a logical construct called a measure group ...
Get Microsoft® SQL Server® 2008 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.
