createDWH.sql

create view [dbo].[dim_Product] as 
select
	[ID]
	,[Name]
from [Product]

CREATE view [dbo].[dim_Client] as
select 
	[ID]
	,[Name]
from [Client]

create view [dbo].[dim_Date] as
select  
	[Day]
   ,[DayName]
   ,[Month]
   ,[MonthName]
   ,[Year]
from [Date]

create view [dbo].[dim_Invoice] as
select 
	[ID]
	,[Number]      
from [Invoice_Header]

create view [dbo].[dim_Price] as
select 
	[Price]
from [Invoice_Detail]

create view [dbo].[fact_Invoice] as
select 
	[Invoice_Detail].[ID]
	,[Product]
	,[Date]
	,[Client]
	,[Price]
	,[Amount]
	,[Qty]
from [Invoice_Detail]
	left join [Invoice_Header]
	on [Invoice_Detail].[ID] = [Invoice_Header].[ID]