Database Reference
In-Depth Information
10. Click next to advance the wizard.
11. Change the name of your new dimension to the
DimStores
in the Completing the
Wizard dialog window by removing the space between the word Dim and Stores.
12. Click Finish to complete the wizard.
13. Use the build menu to verify that the DimStores 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 Date Dimension
The Date dimension has nine columns. Most of these columns will be combined into name and key pairs so
that we will end up with only five attributes. An example of t\his is combining the Yearname column and year
column into one dimensional attribute called year. Unfortunately, the wizard is unable to completely configure
the attributes. Therefore, we select only a few columns during the wizard's creation process and configure
the attributes after the wizard is complete.
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. Click next to advance to the Specify Source
information dialog window.
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 DimDates table.
5.
in the “Key columns” list box, choose the DateKey column.
6.
in the “name column” dropdown box, choose the Datename column and click next
to advance to the Select Dimension Attributes dialog window.
7.
Check the Date Key, Full Date, Month, Quarter, and Year checkboxes in the Select
Dimension Attributes dialog window (Figure
9-52
).
