Database Reference
In-Depth Information
Table 10-6.
The Initial Property Settings for the DimDates Dimension
Attribute
Property Name
Value
Date Key
Name
Date
KeyColumn
DimDates.DateKey
NameColumn
DimDates.DateName
AttributeHierarchyVisible
True
Full Date
Name
FullDate
KeyColumn
DimDates.DateKey
NameColumn
DimDates.FullDate
AttributeHierarchyVisible
True
Month
Name
Month
KeyColumn
DimDates.Year
DimDates.Quarter,
DimDates.Month
NameColumn
DimDates.MonthName
AttributeHierarchyVisible
True
Quarter
Name
Quarter
KeyColumn
DimDates.Year
DimDates.Quarter
NameColumn
DimDates.QuarterName
AttributeHierarchyVisible
True
Year
Name
Year
KeyColumn
DimDates.Year
NameColumn
DimDates.YearName
AttributeHierarchyVisible
True
3.
Create a user-defined hierarchy for dates grouped by month, quarters, and years.
You can do this by dragging and dropping the Year attribute to the Hierarchies
section of the dimension editor. This creates a new hierarchy.
4.
Drag and drop the Quarter attribute just beneath the Year attribute in the new
hierarchy (Figure
10-17
).
5.
Drag and drop the month attribute just beneath the Quarter attribute in the new
hierarchy (Figure
10-17
).
6.
Drag and drop the Date attribute just beneath the month attribute in the new
hierarchy (Figure
10-17
).
