December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...