Logical Data Warehouse Design - Data Warehouse Systems: Design and Implementation - page 152

Fig. 5.23 Browsing the hierarchy of the Product dimension
Fig. 5.24 Definition of the Time dimension
We next explain how the Time dimension is defined in Analysis Services. As
shown in Fig. 5.24 , the dimension has the hierarchy denoted Calendar ,which
is defined using the attributes Year , Semester , Quarter , MonthNumber ,and
TimeKey . Since specific MDX functions can be used with time dimensions,
the Type property of the dimension must be set to Time . Further, Analysis
Services needs to identify which attributes in a time dimension correspond to
the typical subdivision of time. This is done by defining the Type property of
the attributes of the dimension. Thus, the attributes DayNbMonth , Month-