O'Reilly logo

Pro SQL Server 2008 Analysis Services by Philo Janus Guy Fouché

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Cubes, Dimensions, and Measures

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.

A cube

Figure 2.1. A cube

Cubes and Their Components

A cube is a collection of numeric data organized by arrays of discrete identifiers. Cubes were created to give a logical structure to the pivot table approach to analyzing large amounts of numerical data.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required