Time hierarchy

The Time hierarchy contains time-specific attributes such as Year, Quarter, Month, and Day.

The Time hierarchy contains the following attributes.

Attribute

Description

Example

Day

Calendar date of purchase.

5/14/09, 12/26/12.

Month

Month of purchase.

Jul 10, Aug 12.

Month of Year

Calendar month of purchase.

January, November.

Quarter

Calendar quarter of purchase.

Q2 10, Q3 12.

Year

Calendar year of purchase.

2009, 2010, 2011.

Refer to the following image for an understanding of the logical relationships of all attributes for the Time hierarchy.