Dimension.Date - WideWorldImportersDW

WideWorldImportersDW

- WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Dimension
Name	Date
Modules	Movement, Order, Purchase, Sale, Transaction

Date dimension

Columns

		Name	Data type	Description
	1	Date	date	DW key for date dimension (actual date is used for key)
DW key for date dimension (actual date is used for key)
	2	Day Number	int	Day of the month
Day of the month
	3	Day	nvarchar(10)	Day name
Day name
	4	Month	nvarchar(10)	Month name (ie September)
Month name (ie September)
	5	Short Month	nvarchar(3)	Short month name (ie Sep)
Short month name (ie Sep)
	6	Calendar Month Number	int	Calendar month number
Calendar month number
	7	Calendar Month Label	nvarchar(20)	Calendar month label (ie CY2015Jun)
Calendar month label (ie CY2015Jun)
	8	Calendar Year	int	Calendar year (ie 2015)
Calendar year (ie 2015)
	9	Calendar Year Label	nvarchar(10)	Calendar year label (ie CY2015)
Calendar year label (ie CY2015)
	10	Fiscal Month Number	int	Fiscal month number
Fiscal month number
	11	Fiscal Month Label	nvarchar(20)	Fiscal month label (ie FY2015Feb)
Fiscal month label (ie FY2015Feb)
	12	Fiscal Year	int	Fiscal year (ie 2016)
Fiscal year (ie 2016)
	13	Fiscal Year Label	nvarchar(10)	Fiscal year label (ie FY2015)
Fiscal year label (ie FY2015)
	14	ISO Week Number	int	ISO week number (ie 25)
ISO week number (ie 25)

Relations

Foreign table	Primary table	Join	Title / Name / Description
Fact.Movement	Dimension.Date	Fact.Movement.Date Key = Dimension.Date.Date	FK_Fact_Movement_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Movement.Date Key = Dimension.Date.Date Name: FK_Fact_Movement_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Order	Dimension.Date	Fact.Order.Order Date Key = Dimension.Date.Date	FK_Fact_Order_Order_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Order.Order Date Key = Dimension.Date.Date Name: FK_Fact_Order_Order_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Order	Dimension.Date	Fact.Order.Picked Date Key = Dimension.Date.Date	FK_Fact_Order_Picked_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Order.Picked Date Key = Dimension.Date.Date Name: FK_Fact_Order_Picked_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Purchase	Dimension.Date	Fact.Purchase.Date Key = Dimension.Date.Date	FK_Fact_Purchase_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Purchase.Date Key = Dimension.Date.Date Name: FK_Fact_Purchase_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Sale	Dimension.Date	Fact.Sale.Delivery Date Key = Dimension.Date.Date	FK_Fact_Sale_Delivery_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Sale.Delivery Date Key = Dimension.Date.Date Name: FK_Fact_Sale_Delivery_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Sale	Dimension.Date	Fact.Sale.Invoice Date Key = Dimension.Date.Date	FK_Fact_Sale_Invoice_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Sale.Invoice Date Key = Dimension.Date.Date Name: FK_Fact_Sale_Invoice_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Transaction	Dimension.Date	Fact.Transaction.Date Key = Dimension.Date.Date	FK_Fact_Transaction_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Transaction.Date Key = Dimension.Date.Date Name: FK_Fact_Transaction_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date

Unique keys

	Key name	Columns	Description
	PK_Dimension_Date	Date	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Used by

Name
Dimension.Date
Fact.Movement
Fact.Order
Fact.Order
Fact.Purchase
Fact.Sale
Fact.Sale
Fact.Transaction

Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59