Dim.Date
This feature is available in Enterprise and Ultimate editions.
This table contains Type 1 data for dates.
Table Description
Column Name | Description | Datatype |
DateKey | Datamart unique identifier for this date | int |
Date | Date | datetime |
YearNumber | Year component as a number (2009) | int |
YearName | Year component as a string ('2009') | varchar(10) |
SemesterNumber | Semester of the year component as a number (200901, 200902) | int |
SemesterName | Semester component as a string ('H1') | varchar(2) |
SemesterYearName | Semester and Year information as a string ('H1 2009') | varchar(10) |
QuarterNumber | Quarter and year as a number (200901, 200902, 200903, 200904) | int |
QuarterName | Quarter component as a string ('Q1', 'Q2', 'Q3', 'Q4') | varchar(10) |
QuarterYearName | Quarter and year as a string ('Q1 2009') | varchar(10) |
MonthNumber | Month and year as a number (200901 = January 2009) | int |
MonthFullName | Full Month Name ('January') | varchar(20) |
MonthShortName | Short Name for the month ('Jan') | varchar(3) |
MonthYearName | Month and Year as a string ('January 2009') | varchar(20) |
MonthShortYearName | Month Short name and year as a string ('Jan 2009') | varchar(20) |
DayNumber | Day component as a number (1, 2, 3...) | int |
DayName | Day Component as a string ('01', '02', '03'...) | varchar(2) |
DateDisplayDate | Complete Date as a string with full month ('January 1, 2009') | varchar(20) |
DisplayDateShort | Short Date as a string ('01/01/2009') | varchar(20) |
WeekDayNumber | Day of the week as a number ( =Sunday - 7=Saturday) | int |
WeekDayName | Day of the week as a string ('Monday', Tuesday'...) | varchar(20) |
WeekendFlag | Does this day represent a weekend (Y/N) | varchar(1) |
DaysInMonth | Total number of days in the given month | int |