Database Reference
In-Depth Information
In Chapter
12
we discuss configuring, building, deploying, and processing dimensions, for now let's create
our dimensions in the following exercise.
eXerCISe 9-2: CreatING the DIMeNSIONS
in this exercise, you create the dimensions for the SSAS project. in our current design we have five
dimensions to create: titles, authors, stores, dates, and orders. Let's start with the titles dimension.
Note:
if the solution from the previous exercise is closed, reopen it and remember to right-click the menu
item, select Run as Administrator, and answer Yes to close the UAC.
Create the titles Dimension
1.
Start the Dimension Wizard by right-clicking the Dimensions folder in Solution
Explorer, as shown in Figure
9-34
.
2.
When the wizard opens, click next to advance to the Select Creation Method dialog
window (Figure
9-35
). Choose the Use an Existing Table radio button, and click next
to advance to the Specify Source information dialog window.
3.
Choose DWPubsSalesTables in the “Data source view” dropdown box of the Specify
Source information dialog window, as shown in Figure
9-36
.
4.
in the “Main table” dropdown box, choose the DimTitles table, as shown in
Figure
9-37
.
5.
in the “Key columns” list box, choose the TitleKey column, as shown in Figure
9-38
.
6.
in the “name column” dropdown, choose the Titlename column, as shown in
Figure
9-39
. Click next to advance to the Select Related Tables dialog window.
7.
Check both the DimDates and DimPublishers checkboxes in the Select Related
Tables dialog window, as shown in Figure
9-40
. Click next to advance to the Select
Dimension Attributes dialog window.
8.
Check all the attributes except for the Date name, Month name, Quarter name, Year
name, and Publisher name in the Select Dimension Attributes dialog window, as
shown in Figure
9-41
.
9.
Change the attribute types for each of the attributes listed here (Figure
9-43
), and
then click next to advance to the Completing the Wizard dialog window:
•
Title id as Slowly Changing Dimension - original id
•
Date Key as Calendar
➤ Date
•
Full Date as Calendar
➤ Date
•
Month as Calendar
➤ Month
