Database Reference
In-Depth Information
•
Quarter as Calendar
➤ Quarter
•
Year as Calendar
➤ Year
•
Publisher id as Slowly Changing Dimension - original id
10. Rename the dimension from Dim Titles to
DimTitles
(Figure
9-44
), and then click
Finish to complete the wizard.
11. Use the Build menu to verify that the DimTitles dimension builds successfully. if it
does not, troubleshoot the problem or delete the dimension from Solution Explorer
and create the dimension again, being careful to include any steps you may have
omitted.
Create the authors Dimension
The Authors dimension contains only four columns. next we will combine two columns (iD and name) into a
single attribute called Author. The other two columns will each be configured as a separate attribute of the
Authors dimension.
1.
Start the Dimension Wizard by right-clicking the Dimensions folder in Solution
Explorer.
2.
Click next to advance to the Select Creation Method dialog window, and choose the
Use an Existing Table radio button.
3.
Click next to advance to the Specify Source information dialog window, and choose
DWPubsSalesTables in the “Data source view” dropdown box, as shown in
Figure
9-49
.
4.
in the “Main table” dropdown box, choose the DimAuthors table.
5.
in the “Key columns” list box, choose the AuthorKey column.
6.
in the “name column” dropdown box, choose the Authorname column, and click
next to advance to the Select Dimension Attributes dialog window.
Note:
When we created the Titles dimension, the Select Related Tables dialog window was the next to be
displayed. The wizard displays that dialog window only if the relationship lines in the data source view
indicate that the main table is a parent table to a child table; therefore, you will not see this window when
creating the DimAuthors table.
