Date Attribute Reference
This article lists the date attributes that belong to the date dimension hierarchy.
Each attribute has one or more attribute labels. An attribute label (also known as displayForm) provides a different means of representing an attribute. For example, you can have a date as 23-11-2008 (format: dd-mm-yyyy), 11/23/2008 (format: mm/dd/yyyy), and so on.
Week/Year is the only non-hierarchical chronological date attribute. It does not fit into the Year > Quarter > Month > Date hierarchy because weeks often span the beginning and end of a month (or quarter, or year).
Date
Description: Slices data across a chronological set of dates (at the day level of granularity), including date, month, and year values. Example: 12/23/2012 Labels:
mm/dd/yyyyyyyy/dd/mmm/d/yy (no leading zeros)Long (Mon, Jan 1, 2010)dd/mm/yyyydd-mm-yyyy
Day of Month
Description: Categorizes data by generic day of the month, represented numerically with values D1, D2, D3, …, D31. Example: D23 Labels: default (a number from 1 to 31 inclusive)
Day of Quarter
Description: Categorizes data by generic day of the quarter, represented numerically with values D1, D2, D3, …, D92. Example: D45 Labels: default (a number from 1 to 92 inclusive)
Day of Week (Mon-Sun)
Description: Categorizes data by generic day of the (EU) week, represented numerically starting with D1 for all Mondays, followed by D2, D3, …, D7. Example: D3 (for Wednesday) Labels:
Short (Mon)Long (Monday)Number (1=Monday)
Day of Week (Sun-Sat)
Description: Categorizes data by generic day of the (US) week, represented numerically starting with D1 for all Sundays, followed by D2, D3, …, D7. Example: D3 (for Tuesday) Labels:
Short (Sun)Long (Sunday)Number (1=Sunday)
Day of Year
Description: Categorizes data by generic day of the year, represented numerically with values D1, D2, D3, …, D366. Example: D286 Labels: default (a number from 1 to 366 inclusive)
Month/Year
Description: Breaks data across a chronological set of months, including month and year values. Example: January 2010 Labels:
Short (Jan 2010)Long (January 2010)Number (1/2010)
Month
Description: Categorizes data by generic month, represented by name or by number out of 12. Example: January Labels:
Short (Jan)Long (January)Number (M1)M/Q (M1/Q2)
Month of Quarter
Description: Categorizes data by generic month of the quarter, represented numerically with values M1, M2, or M3. Example: M1 Labels: Number (a number from 1 to 3 inclusive)
Quarter/Year
Description: Slices data across a chronological set of quarters, including both quarter and year values. Example: Q1/2010 Labels: US Short
Quarter
Description: Categorizes data by generic quarter of the year, represented numerically with values of Q1, Q2, Q3, or Q4. Example: Q2 Labels: default (a number from 1 to 4 inclusive)
Week (Mon-Sun)/Year
Description: Slices data across a chronological set of (EU) weeks, including both week and year values.
Week/Year is the only non-hierarchical chronological date attribute. It does not fit into the Year > Quarter > Month > Date hierarchy because weeks often span the beginning and end of a month (or quarter, or year).
Examples:
W38/2008September 15, 2008 - September 21, 2008
Labels:
Week #/Year (W1/2010)Week StartingFrom - To
Week (Mon-Sun)
Description: Categorizes data by generic (EU) week of the year, represented numerically with values W1, W2, W3, …, W53. Example: W51 Labels: Number EU (a number from 1 to 53 inclusive)
Week (Mon-Sun) of Qtr
Description: Categorizes data by generic (EU) week of the quarter, represented numerically with values W1, W2, W3, …, W14. Example: W10 Labels: Number EU (a number from 1 to 14 inclusive)
Week (Sun-Sat)/Year
Description: Slices data across a chronological set of (US) weeks, including both week and year values.
Week/Year is the only non-hierarchical chronological date attribute. It does not fit into the Year > Quarter > Month > Date hierarchy because weeks often span the beginning and end of a month (or quarter, or year).
Examples:
W38/2008September 14, 2008 - September 20, 2008
Labels: The labels marked with (Cont.) show both the last and the first week in cases where a week spans the boundary of a quarter or year.
Week #/Year (W1/2010)Week StartingFrom - ToWeek #/Year (Cont.)Wk/Qtr/Year (Cont.)Wk/Qtr/Year
Week (Sun-Sat)
Description: Categorizes data by generic (US) week of the year, represented numerically with values W1, W2, W3, …, W53. Example: W51 Labels: Number US (a number from 1 to 53 inclusive)
Week (Sun-Sat) of Qtr
Description: Categorizes data by generic (US) week of the quarter, represented numerically with values W1, W2, W3, …, W14. Example: W10 Labels: Number US (a number from 1 to 14 inclusive)
Year
Description: Slices data across a chronological set of years. Example: 2012 Labels: Year