Date 實體的參考Reference for Date entity

[日期] 類別包含用來定義資料模型中日期參考的 Date 實體。The Date category contains the Date entity used to define date references in the data model.

日期Date

Date 實體代表跨多個資料倉儲實體所參考的日期。The Date entity represents dates that are referenced across multiple data warehouse entities.

屬性Property 描述Description 範例Example
DateKeyDateKey 資料倉儲中此日期的唯一識別碼Unique identifier for this date in the data warehouse 2016070320160703
FullDateFullDate 此日期以完整日期/時間格式表示This date represented in full Date/Time format 7/3/2016 12:00:00 AM7/3/2016 12:00:00 AM
DayOfWeekDayOfWeek 週中的日Day of week 11
DayOfMonthDayOfMonth 月中的日Day of month 33
DayOfYearDayOfYear 年中的日Day of year 185185
WeekOfYearWeekOfYear 年中的週Week of year 2828
MonthOfYearMonthOfYear 年中的月Month of the year 77
CalendarQuarterCalendarQuarter 日曆季度Calendar quarter 33
CalendarYearCalendarYear 日曆年度Calendar year 20162016
DateKeyDateKey 資料倉儲中此日期的唯一識別碼Unique identifier for this date in the data warehouse 2016070320160703
FullDateFullDate 此日期以完整日期/時間格式表示This date represented in full Date/Time format 7/3/2016 12:00:00 AM7/3/2016 12:00:00 AM
DayOfWeekDayOfWeek 週中的日Day of week 11
DayOfMonthDayOfMonth 月中的日Day of month 33
DayOfYearDayOfYear 年中的日Day of year 185185
WeekOfYearWeekOfYear 年中的週Week of year 2828
MonthOfYearMonthOfYear 年中的月Month of the year 77
CalendarQuarterCalendarQuarter 日曆季度Calendar quarter 33
CalendarYearCalendarYear 日曆年度Calendar year 20162016