Contoso-schema-beschrijving:

Koppelingen:

FactSales<-->DimDate:=Datekey
FactSales<-->DimPromotion:=PromotionKey
FactSales<-->DimChannel:=ChannelKey
FactSales<-->DimProduct:=ProductKey
FactSales<-->Stores:=Storekey
DimProduct<-->DimProductSubcategory:=ProductSubcategoryKey
DimProductSubcategory<-->DimProductCategory:=ProductCategoryKey
Stores<-->DimEntity:=EntityKey
Stores<-->DimGeography:=GeographyKey

FactSales:
TotalCost:=SalesQuantity*UnitCost-ReturnQuantity*UnitCost
SalesAmount:=SalesQuantity*UnitPrice-DiscountAmount
DiscountAmount:=DimPromotion!DiscountPercent*UnitPrice*DiscountQuantity