Redaguoti

Bendrinti naudojant


Reference for dates entity

The dates category contains the date entity used to define date references in the data model.

dates

The date entity represents dates that are referenced across multiple data warehouse entities.

Property Description Example
dateKey Unique identifier for this date in the data warehouse. 20160703
fullDate This date represented in full Date/Time format. 7/3/2016 12:00:00 AM
dayOfWeek Day of week 1
dayOfMonth Day of month 3
dayOfYear Day of year 185
weekOfYear Week of year 28
monthOfYear Month of the year 7
calendarQuarter Calendar quarter 3
calendarYear Calendar year 2016
dateKey Unique identifier for this date in the data warehouse. 20160703
fullDate This date represented in full Date/Time format. 7/3/2016 12:00:00 AM
dayOfWeek Day of week 1
dayOfMonth Day of month 3
dayOfYear Day of year 185
weekOfYear Week of year 28
monthOfYear Month of the year 7
calendarQuarter Calendar quarter 3
calendarYear Calendar year 2016

Next steps