Now we'll make a few changes
to the Calendar.Time dimension to more precisely establish it as a time
dimension.
19.
Click the Calendar.Time
dimension to highlight / select it.
20.
Click the Advanced tab
of the Properties pane.
21.
Change the Type field
for the Calendar.Time dimension to Time, as shown below.
Illustration 35:
The Calendar.Time Dimension Advanced Properties
22.
Click the Calendar Year
level to highlight / select it.
23.
Click the Advanced tab
of the Properties pane.
24.
Change the Level Type
field for the Calendar Year level to Years, as shown in the
following illustration.
Illustration 36:
The Calendar.Time Dimension, Calendar Year Level Advanced Properties
25.
Click the Calendar Quarter
level to highlight / select it.
26.
Click the Advanced tab
of the Properties pane.
27.
Change the Level Type
field for the Calendar Quarter level to Quarters, as shown in the
Illustration 37 below.
Illustration 37:
The Calendar.Time Dimension, Calendar Quarter Level Advanced Properties
28.
Click the Calendar Month
level to highlight / select it.
29.
Click the Advanced tab
of the Properties pane.
30.
Change the Level Type
field for the Calendar Month level to Months, as shown in the
following illustration.
Illustration 38:
The Calendar.Time Dimension, Calendar Month Level Advanced Properties
31.
Click the Date level to
highlight / select it.
32.
Click the Advanced tab
of the Properties pane.
33.
Change the Level Type
field for the Date level to Days, as shown in the following
illustration.
Illustration 39:
The Calendar.Time Dimension Date Level Advanced Properties
I typically style the
lowest level in the Date hierarchy as Date; calendar, fiscal, and
perhaps other date hierarchies would typically share Date as a common
lowest level, and thus I give it a name that will serve all equally well.
Having handled the Calendar.Time
member properties that will be created in our cube, let's do something
similar for the Store dimension. The Store dimension consists of
member naming that makes intuitive sense, as we will see upon our initial cube
generation, so we will simply swap the name for the id number that previously
occupied the Store member level.
34.
Right-click the store_id
dimension.
35.
Select Rename from the
context menu, and type in Store.
36.
Click the Advanced tab
in the Properties pane.
37.
Select the All Caption
property.
38.
Change the All Caption
property to read "All Stores."
39.
Drag the store_id field
from the store table over to drop onto the Store dimension in the
cube tree.
40.
Right-click the store_id
level that appears.
41.
Select Rename from the
context menu, and type in Store.
42.
Click the Basic tab in
the Properties pane.
43.
Select the Member Name
Column property.
44.
Click the ellipses button ("..").
The Select Column
dialog appears.
45.
Select the store_name
column by clicking.
46.
Click OK.
47.
Press the Enter key.
The Properties
pane for the new Store level, with the modification we have put into
place, should appear as shown below:
Illustration 40:
The Modified Properties, Store Level Member of the Store Dimension
» 
Comment and Contribute
