Database Reference
In-Depth Information
9.
When you have completed this, the dialog window should look like Figure
9-50
. Click
next to advance the wizard.
10. Change the name of your new dimension to the
DimAuthors
in the Completing the
Wizard dialog window by removing the space between the word Dim and Authors.
11. Click Finish to complete the wizard.
12. 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 go
through the steps again, being careful to include any steps you may have omitted.
Create the Stores Dimension
We now have two dimensions created and built. Let's work on the Stores dimension next. This process will
be almost identical to steps required to create the Authors dimension.
1.
Start the Dimension Wizard by right-clicking the Dimensions folder in Solution
Explorer.
2.
Click the next button to advance to the Select Creation Method dialog window, and
choose the Use an Existing Table radio button.
3.
Choose DWPubsSalesTables in the “Data source view” dropdown box within the
Specify Source information dialog window.
4.
in the “Main table” dropdown box, choose the DimStores table.
5.
in the “Key columns” list box, choose the StoreKey column.
6.
in the “name column” dropdown box, choose the Storename column, and click next
to advance to the Select Dimension Attributes dialog window.
7.
Check the Store key and Store iD checkboxes in the Select Dimension Attributes
dialog window.
8.
Change the attribute type for the following attribute:
•
Store id as Slowly Changing Dimension - original id
9.
When you have completed this, the dialog window should look like Figure
9-51
.
Figure 9-51.
Selecting the attributes for the Stores dimension
