Database Reference
In-Depth Information
Table 10-7.
(continued)
Attribute
Property Name
Value
Date Key
Name
PublishedDate
KeyColumn
DimDates.DateKey
NameColumn
DimDates.DateName
AttributeHierarchyVisible
True
Month
Name
PublishedMonth
KeyColumn
DimDates.Year,
DimDates.Quarter,
DimDates.Month
NameColumn
DimDates.MonthName
AttributeHierarchyVisible
True
Quarter
Name
PublishedQuarter
KeyColumn
DimDates.Year,
DimDates.Quarter
NameColumn
DimDates.QuarterName
AttributeHierarchyVisible
True
Year
Name
PublishedYear
KeyColumn
DimDates.Year
NameColumn
DimDates.YearName
AttributeHierarchyVisible
True
3.
Create a user-defined hierarchy for titles grouped by title types by dragging and
dropping the TitleType attribute to the Hierarchies section of the dimension editor.
This creates a new hierarchy.
4.
Drag and drop the Title attribute just beneath the TitleType attribute in the new
hierarchy, as shown in Figure
10-18
.
5.
Rename the new hierarchy to TitlesByType using the Properties window. when you
are finished, your dimension editor should look like Figure
10-18
.
6.
Create a second user-defined Hierarchy for Titles grouped by Publishers. You can do
this by dragging and dropping the Publisher attribute to the Hierarchies section of
the dimension editor. This creates a new hierarchy.
7.
Afterward, drag and drop the Title attribute just beneath the Publishers attribute in
the new hierarchy, as shown in Figure
10-18
.
8.
Rename the new hierarchy to TitlesByPublisher using the Properties window. when
you are finished, your dimension editor should look like Figure
10-18
.
