Jump to: navigation, search

EVENT_DATE Dimension

The EVENT_DATE dimension is a static dimension that stores information about dates. The ETL Initialize job populates this table determining date values from your system’s locale settings.

The EVENT_DATE Dimension
Field Data Type Description
EVENT_DATE_KEY int Primary key of this table.
EVENT_DATE datetime Date of the event in “YYYY-M-D 0:0:0.0” format.
DAY_NAME nvarchar(32) Text name of the day (“Monday”, “Tuesday”, and so on).
DAY_NUM_IN_WEEK int Day of the week (1–7).
DAY_NUM_IN_MONTH int Day of the month (1–31).
DAY_NUM_IN_YEAR int Day of the year (1–366).
WEEK_NUM_IN_YEAR int Week number of the year (1–53).
WEEK_START_DATE datetime Date of the first day of the week in “YYYY-M-D 0:0:0. 0” format.
WEEK_END_DATE datetime Date of the last day of the week in “YYYY-M-D 0:0:0. 0” format.
MONTH_NAME nvarchar(32) Text name of the month—for example, “January”.
MONTH_NUM_IN_YEAR int Month of the year (1–12).
QUARTER_NUM_IN_YEAR int Quarter (1–4).
YEAR_NUM int Year—for example, 2011.
EVENT_DATE_STR nvarchar(10) String representation of the date in "YYYY-MM-DD" format

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 19 December 2017, at 03:26.