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 |