Page 26 - DCAP606_BUSINESS_INTELLIGENCE

Unit 2: Multidimensional Analysis

Notes
Table 2.2: Dimension Table for Time Dimension
Year Quarter Month

1999 Quarter 1 Jan
1999 Quarter 1 Feb
1999 Quarter 1 Mar
1999 Quarter 2 Apr
1999 Quarter 2 May
1999 Quarter 2 Jun
1999 Quarter 3 Jul
1999 Quarter 3 Aug
1999 Quarter 3 Sep
1999 Quarter 4 Oct
1999 Quarter 4 Nov
1999 Quarter 4 Dec
Source: http://msdn.microsoft.com/en-us/library/ms174935.aspx

Did u know? The Year, Quarter, and Month attributes are used to construct a user-defined
hierarchy, named Calendar, in the time dimension.

Task Prepare a table hierarchy of employees according to their salary.
The relationship between the levels and members of the Calendar dimension is shown in
Figure 2.4.

Figure 2.4: Relationship between the Levels and Members of the Calendar Dimension

Source: http://i.msdn.microsoft.com/dynimg/IC165224.gif

Notes Any hierarchy other than the default two-level attribute hierarchy is called a user-
defined hierarchy.

LOVELY PROFESSIONAL UNIVERSITY 21