Cubes, Dimensions, and Measures

  • Philo Janus
  • Guy Fouché


Cubes, dimensions, and measures are the fundamental parts of any OLAP solution. Let’s consider the array of spreadsheets from Chapter 1, shown here again in Figure 2-1. At the most basic, the whole collection is a cube. In this chapter, you’ll look at how this model relates to the concepts you need to grasp in order to understand OLAP and Analysis Services.
Figure 2-1

A cube


Data Warehouse Dimension Table Fact Table Star Schema Data Mart 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Philo Janus and Guy Fouché 2010

Authors and Affiliations

  • Philo Janus
  • Guy Fouché

There are no affiliations available

Personalised recommendations