As a part of making our
cube more user-friendly for information consumers, we wish to substitute the
dimension names that it currently presents with more intuitive dimension
fields. Let's begin with the time_by_day table.
In a case where we may
not be familiar with the nature of the data or the characteristics of the
fields in a given table, such as our time_by_day table, we can browse the data
to get a look at its makeup.
Click the upper portion (where
the name appears) of the time_by_day table to select the table.
Right-click and select Browse
Data from the context menu, as shown in Illustration 40.
Illustration 40: Select
Browse Data to View a Sample of a Table's Data
Data Viewer appears, as shown in Illustration 41 below.
Partial View of the Browse Data Viewer
Close the viewer after
reviewing the data columns and the formats of their contents.
29. In the Cube Tree, expand the existing Calendar.Time
dimension by clicking the "+" sign to its immediate left.
Beginning with the Calendar.Time
dimension, and proceeding to the remaining dimensions, we will substitute a
more user-friendly field than the original key number, from the related
Select the Calendar Time
dimension level member (the single level under the Calendar.Time dimension), as
Calendar.Time Dimension as Currently Constructed
Right-click the Calendar Time
dimension level member.
Select Delete from the context
Click Yes at the Confirm
Level Delete dialog to delete the member.
Perform steps 33 through 35 for
the Store and Category dimension level members, respectively.
We should now have each
dimension in place, with no levels under each of the Calendar.Time, Store
and Category dimensions. We will add dimension levels from the
dimension tables in the next steps.
Drag the following fields from the
time_by_day table over to drop onto the Calendar.Time dimension in the
cube tree, in the order shown:
Right-click on each of the
above newly added dimension levels, and rename each, respectively, to the
- Calendar Year
- Calendar Quarter
- Calendar Month
Dragging the fields
onto the folder in the order above, then changing their names, will result in
their alignment as shown below:
Calendar.Time Dimension with New Member Additions / Modifications