Featured Database Articles MS SQL
November 11, 2002Introduction to SQL Server 2000 Analysis Services: Working with the Cube Editor By William Pearson
We should now have each
dimension in place, with no levels under each. We will add dimension levels
from the dimension tables in the next steps.
20.
Drag the following fields from
the time_by_day table over to drop onto the Calendar.Time
dimension folder, in the order shown:
the_year
quarter
the_month
the_date
Dragging the fields
onto the folder in the order above will result in their alignment as shown
below:
Illustration 36: Calendar.Time Dimension with New Member Additions
21.
Right-click on each of the
above newly added dimension members and rename each, respectively, to the
following:
Calendar Year
Calendar Quarter
Calendar Month
Date
22.
Drag the account_num
field from the customer table over to drop onto the Customer
dimension folder.
23.
Right-click on the newly added account_num
member and rename it as Account No.
24.
Drag the sku field from
the product table over to drop onto the Product dimension folder.
25.
Right-click on the newly added sku
member and rename it as SKU.
The modified dimension
section of the cube tree appears as shown below:
Illustration 37: The Newly Modified Dimensions in the ANSYS05 Cube Tree
26.
Click the Calendar.Time
dimension to highlight/select it.
27.
Click the Advanced tab
of the Properties pane.
28.
Change the Type field
for the Calendar.Time dimension to Time, as shown below.
Illustration 38: The Calendar.Time Dimension Advanced Properties
29.
Click the Calendar Year
level to highlight/select it.
30.
Click the Advanced tab
of the Properties pane.
31.
Change the Level Type
field for the Calendar Year level to Years, as shown in the
following illustration.
Illustration 39: The Calendar.Time Dimension, Calendar Year Level Advanced Properties
32.
Click the Calendar Quarter
level to highlight/select it.
33.
Click the Advanced tab
of the Properties pane.
34.
Change the Level Type
field for the Calendar Quarter level to Quarters, as shown in the
following illustration.
Illustration 40: The Calendar.Time Dimension, Calendar Quarter Level Advanced Properties
35.
Click the Calendar Month
level to highlight/select it.
36.
Click the Advanced tab
of the Properties pane.
37.
Change the Level Type
field for the Calendar Month level to Months, as shown in the
following illustration.
Illustration 41: The Calendar.Time Dimension, Calendar Month Level Advanced Properties
38.
Click the Date level to
highlight/select it.
39.
Click the Advanced tab
of the Properties pane.
40.
Change the Level Type
field for the Date level to Days, as shown in the following
illustration.
Illustration 42: The Calendar.Time Dimension Date Level Advanced Properties
Page 10: The Cube Editor (Continued)
See All Articles by Columnist William E. Pearson, III
Add databasejournal.com to your favorites
Add databasejournal.com to your browser search box
|
|
Receive news via our XML/RSS
feed
MS SQL Archives
IE 7
Firefox 2.0