Date Attribute Reference

This topic lists the date attributes that belong to a date dimension hierarchy.

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 given month (or quarter, or year).

A label is an alternative way to represent an attribute. The various labels for a Date attribute allow you to represent a particular date in several different ways, such as dd-mm-yyyy, mm/dd/yyyy, and so on.

Contents:

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: :

  • dd-mm-yyyy
  • dd/mm/yyyy
  • Written date (for example, Mon, Jan 1, 2010)
  • m/d/yy (no leading zeros)
  • mm/dd/yyyy
  • yyyy/dd/mm

Day of Month (g)

Description: Categorizes data by generic day of the month, represented numerically with values D1, D2, D3, …, D31.
Example: D23
Labels: A number out of 31

Day of Quarter (g)

Description: Categorizes data by generic day of the quarter, represented numerically with values D1, D2, D3, …, D92.
Example: D45
Labels: A number out of 92

Day of Week (Mon-Sun) (g)

Description: Categorizes data by generic day of the (EU) week, represented numerically starting with D1 for all data from Mondays, followed by D2, D3, …, D7.
Example: D3
Labels:

  • Long name (for example, Monday)
  • Number out of 7 (for example, 1 for Monday)
  • Short name (for example, Mon)

Day of Week (Sun-Sat) (g)

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:

  • Long name (for example, Sunday)
  • Number out of 7 (for example, 1 for Sunday)
  • Short name (for example, Sun)

Day of Year (g)

Description: Categorizes data by generic day of the year, represented numerically with values D1, D2, D3, …, D366.
Example: D286
Labels: A number out of 366

Month_Year

Description: Breaks data across a chronological set of months – including month, and year values.
Example: January 2010
Labels:

  • January 2010
  • 1/2010
  • Jan 2010

Month (g)

Description: Categorizes data by generic month, represented by name or by number out of 12.
Example: January
Labels:

  • Full month name (for example, January)
  • Month/Quarter (for example, M1/Q2)
  • Number out of 12 (for example, M1 for January)
  • Short month name (for example, Jan)

Month of Quarter (g)

Description: Categorizes data by generic month of the quarter, represented numerically with values M1, M2, or M3.
Example: M1
Labels: A number out of 3

Quarter_Year

Description: Slices data across a chronological set of quarters – including both quarter and year values.
Example: Q1/2010
Labels: Quarter/Year

Quarter (g)

Description: Categorizes data by generic quarter of the year, represented numerically with values of Q1, Q2, Q3, or Q4.
Example: Q2
Labels: A number out of 4

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 given month (or quarter, or year).

Examples:

  • September 15, 2008-September 21, 2008
  • W38 / 2008
  • Week of Mon 06/17/2009

Labels:

  • Time range: from {date} – to {date}
  • Week number of year / Year
  • Starting date of week

Week (Mon-Sun) (g)

Description: Categorizes data by generic (EU) week of the year, represented numerically with values W1, W2, W3, …, W53.
Example: W51
Labels: A number out of 53

Week (Mon-Sun) of Quarter (g)

Description: Categorizes data by generic (EU) week of the quarter, represented numerically with values W1, W2, W3, …, W14.
Example: W10
Labels: A number out of 14

Week (Sun-Sat)_Year

Description: Slices data across historic weeks – incorporating 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 given month (or quarter, or year).

Examples:

  • September 15, 2008-September 21, 2008
  • W38 / 2008
  • Week of Mon 06/17/2009

Labels: Labels marked continuous show the last and first week in cases where an EU-defined week spans the boundary of a quarter or year.

  • Time range: from {date} – to {date}
  • Week number of year / Year (continuous)
  • Week number of year / Year
  • Starting date of week
  • Week number of quarter / Quarter number / Year
  • Week number of quarter / Quarter number / Year (continuous)

Week (Sun-Sat) (g)

Description: Categorizes data by generic (US) week of the year, represented numerically with values W1, W2, W3, …, W53.
Example: W51
Labels: A number out of 53

Week (Sun-Sat) of Quarter (g)

Description: Categorizes data by generic (US) week of the quarter, represented numerically with values W1, W2, W3, …, W14.
Example: W10
Labels: Number out of 14

Year

Description: Slices data across a chronological set of years.
Example: 2012
Labels: Four-digit year