Database Reference
In-Depth Information
Figure 9-15.
Creating the relation
Click on the
Create Hierarchy
button in the
DimDate
table. Create a hierarchy for
CalendarYear
,
CalendarQuarter
,
EnglishMonthName
, and
FullDateAlternateKey
as shown in Figure
9-16
. (Drag and drop these four
columns under the hierarchy's
HDate
value.)