Database Reference
In-Depth Information
Figure 9-52.
Selecting the attributes for the Date dimension
8.
Change the attribute types for the attributes listed here (Figure
9-52
):
•
Date Key as Calendar
➤ Date
•
Full Date as Calendar
➤ Date
•
Month as Calendar
➤ Month
•
Quarter as Calendar
➤ Quarter
•
Year as Calendar
➤ Year
9.
When you have completed these steps, the dialog window should look like
Figure
9-52
. Click next to advance the wizard.
10. Change the name of your new dimension to
DimDates
in the completing the Wizard
dialog window by removing the space between the word Dim and Dates.
11. Click Finish to complete the wizard.
12. Use the build menu to verify that the DimDates 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 Orders Dimension
The last dimension we need to make is the orders dimension. if you recall, this dimension is a fact
dimension, meaning that all the columns we need to create the dimension are in a fact table. This dimension
is also created using the wizard.
