Table: DimDate

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   DimDate 
 Friendly name   Date 
 Table name   dbo_DimTime 
 Table type   Table 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


No relationships exist

Collapse image Child relations


Relation name  Parent (primary key) columns  Child name  Child type  Child (foreign key) columns 
FK_FactResellerSales_DimDate1 DateKey FactResellerSales Table DueDateKey
FK_FactResellerSales_DimDate DateKey FactResellerSales Table OrderDateKey
FK_FactResellerSales_DimDate2 DateKey FactResellerSales Table ShipDateKey
FK_FactInternetSales_DimDate2 DateKey FactInternetSales Table ShipDateKey
FK_FactInternetSales_DimDate1 DateKey FactInternetSales Table DueDateKey
FK_FactInternetSales_DimDate DateKey FactInternetSales Table OrderDateKey
FK_FactFinance_DimDate DateKey FactFinance Table DateKey
Sales Quota Facts-DimDate CalendarYear, CalendarQuarter Sales Quota Facts View CalendarYear, CalendarQuarter
Sales Summary Facts-DimDate DateKey Sales Summary Facts View OrderDateKey
Sales Summary Facts-DimDate1 DateKey Sales Summary Facts View DueDateKey
Sales Summary Facts-DimDate2 DateKey Sales Summary Facts View ShipDateKey
Currency Rate Facts-DimDate DateKey Currency Rate Facts View DateKey
Total: 12 child relationship(s)

Collapse image Columns


Name  Type  Computed column expression 
FullDateAlternateKey System.DateTime  
DayNumberOfWeek System.Byte  
DayNumberOfMonth System.Byte  
DayNumberOfYear System.Int16  
WeekNumberOfYear System.Byte  
MonthNumberOfYear System.Byte  
CalendarQuarter System.Byte  
CalendarYear System.Int16  
CalendarSemester System.Byte  
FiscalQuarter System.Byte  
FiscalYear System.Int16  
FiscalSemester System.Byte  
CalendarQuarterDesc System.String
'Q' + CONVERT(CHAR (1), CalendarQuarter) +
' CY ' + 
CONVERT(CHAR (4), CalendarYear)
FiscalQuarterDesc System.String
'Q' + CONVERT(CHAR (1), FiscalQuarter) +
' FY ' +
CONVERT(CHAR (4), FiscalYear)
CalendarSemesterDesc System.String
CASE
    WHEN CalendarSemester = 1 
    THEN 'H1 '+'CY ' + CONVERT(CHAR (4), CalendarYear)
    ELSE 'H2 '+ 'CY '+ CONVERT(CHAR (4), CalendarYear)
END
FiscalSemesterDesc System.String
CASE
    WHEN FiscalSemester = 1 
    THEN 'H1 '+'FY '+ CONVERT(CHAR (4), FiscalYear)
    ELSE  'H2 '+'FY '+ CONVERT(CHAR (4), FiscalYear)
END
EnglishDayNameOfWeek System.String  
SpanishDayNameOfWeek System.String  
FrenchDayNameOfWeek System.String  
EnglishMonthName System.String  
SpanishMonthName System.String  
FrenchMonthName System.String  
SimpleDate System.String
DATENAME(mm, FullDateAlternateKey) + ' ' +
DATENAME(dd, FullDateAlternateKey) + ', ' +
DATENAME(yy, FullDateAlternateKey)
MonthName System.String
EnglishMonthName+' '+ CONVERT(CHAR (4), CalendarYear)
CalendarSemesterOfYear System.String
CASE
    WHEN CalendarSemester = 1 
    THEN 'CY H1'
    ELSE  'CY H2'
END
FiscalSemesterOfYear System.String
CASE
    WHEN FiscalSemester = 1 
    THEN 'FY H1'
    ELSE  'FY H2'
END
CalendarQuarterOfYear System.String
'CY Q' + CONVERT(CHAR (1), CalendarQuarter)
FiscalQuarterOfYear System.String
'FY Q' + CONVERT(CHAR (1), FiscalQuarter)
FiscalYearDesc System.String
'FY '+ CONVERT(CHAR (4), FiscalYear)
CalendarYearDesc System.String
'CY '+ CONVERT(CHAR (4), CalendarYear)
DateKey System.Int32  
MonthNameValue System.DateTime
CAST(  
           CONVERT( CHAR(2), MonthNumberOfYear) 
           + '/ ' +  '1/' +
           CONVERT(CHAR(4), CalendarYear) AS DATE
         )
FiscalWeekNumberOfYear System.Int32
CASE 
    WHEN WeekNumberOfYear< 27 
       THEN 
           WeekNumberOfYear + 27
       ELSE 
           WeekNumberOfYear - 26
END
FiscalWeek System.String
CASE 
    WHEN WeekNumberOfYear< 27 
       THEN 
           'FY Week ' + CONVERT(CHAR(2), WeekNumberOfYear + 27)
       ELSE 
           'FY Week ' + CONVERT(CHAR(2), WeekNumberOfYear - 26)
END
CalendarWeek System.String
'CY Week ' +  CONVERT(CHAR(2), WeekNumberOfYear)
FiscalWeekDesc System.String
CASE 
    WHEN WeekNumberOfYear< 27
       THEN 
           'Week ' + CONVERT(CHAR(2), WeekNumberOfYear + 27) + 
           ' FY ' + CONVERT(CHAR (4), FiscalYear)
       ELSE 
           'Week ' + CONVERT(CHAR(2), WeekNumberOfYear - 26) + 
           ' FY ' + CONVERT(CHAR (4), FiscalYear)
END
CalendarWeekDesc System.String
'Week ' +  CONVERT(CHAR(2), WeekNumberOfYear) + 
' CY ' +  CONVERT(CHAR (4), CalendarYear)
Total: 37 column(s)

Collapse image See also


About this documentation