Advanced Dimensions and Measures

In the previous chapter, you learned how to use the Cube Wizard to build several dimensions for our Northwind Sales cube. The Cube Wizard offers the convenience of building several dimensions at once, but it does not provide access to all the features you can build into your dimensions.

You also learned in Chapter 15 how to go beyond the Cube Wizard and build your own hierarchy. (We did this by building a Country - State-Province - City - Postal Code hierarchy in the Geography dimension using the dimension designer.) But that was only a start—we could have done a lot more with that dimension and the others. Let’s now refine what we have built.

Keys and Names

We’ll start with the Shippers dimension. Recall that this ...

Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.

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