Chapter 7. Building a Cube

So we have a collection of dimensions, and a pile of data in our database. The question is—now what? To get value from our data and the work we've done so far, we need to assemble the dimensions into a cube. That's what we're going to do in this chapter. In addition to building a cube from our dimensions, we'll also look into calculated measures (deriving additional values from existing values), partitions (dividing data to ease management), and a deeper dive into aggregations and their design.

A cube in SQL Server Analysis Services is basically a collection of dimensions and measures (and some metadata.) Dimensions must be defined in the database before they can be used in the cube (which is why we did them first!). ...

Get Pro SQL Server 2008 Analysis Services now with the O’Reilly learning platform.

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