Jump to: navigation, search

EVENT_TIME Dimension

The EVENT_TIME dimension—like EVENT_DATE—is a static dimension that stores time information with minute-level granularity.

The EVENT_TIME Dimension
Field Data Type Description
EVENT_TIME_KEY int Primary key of this table.
EVENT_TIME_24 nvarchar(6) 24-hour time, stored in HHMM format—for example, “2301” (for 11:01 PM).
EVENT_TIME_12 nvarchar(8) 12-hour time, including AM or PM—for example, “1101PM”.
TIME_INTERVAL_15MIN int The 15-minute interval in which the time falls (1–96).
TIME_INTERVAL_30MIN int The 30-minute interval in which the time falls (1–48).
TIME_INTERVAL_60MIN int The 60-minute interval in which the time falls (1–24).

Feedback

Comment on this article:

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