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

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