O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

Creating the Other Dimensions

Now you essentially need to go through the whole process of creating a dimension and a hierarchy for the other dimensions (Product and Geography). The process is as follows:

1. Invoke the Dimension Wizard (by right-clicking the Dimensions object in the Solution Explorer).

2. Choose the creation method for the dimension to use the existing table from a data source approach.

3. Specify the Comp Sales2012 DSV data source view.

4. Select the main dimension table to use (Prod_Dimension for the Product dimension and Geo_Dimension for the Geography dimension).

5. Identify the key column of each new dimension (ProductID for the Product dimension and GeoID for the Geography dimension).

6. Select the related tables.

7. Specify ...

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