Table: DimPromotion

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   DimPromotion 
 Friendly name   Promotion 
 Table name   dbo_DimPromotion 
 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_DimPromotion PromotionKey FactResellerSales Table PromotionKey
FK_FactInternetSales_DimPromotion PromotionKey FactInternetSales Table PromotionKey
FactSalesSummary-DimPromotion PromotionKey Sales Summary Facts View PromotionKey
Total: 3 child relationship(s)

Collapse image Columns


Name  Type  Computed column expression 
PromotionKey System.Int32  
PromotionAlternateKey System.Int32  
DiscountPct System.Double  
StartDate System.DateTime  
EndDate System.DateTime  
MinQty System.Int32  
MaxQty System.Int32  
EnglishPromotionName System.String  
SpanishPromotionName System.String  
FrenchPromotionName System.String  
EnglishPromotionType System.String  
SpanishPromotionType System.String  
FrenchPromotionType System.String  
EnglishPromotionCategory System.String  
SpanishPromotionCategory System.String  
FrenchPromotionCategory System.String  
DiscountPctDesc System.Double
DiscountPct * 100
MaxQtyDesc System.Int32
CASE
    WHEN MaxQty IS NULL THEN '0'
    ELSE MaxQty
END
SimpleEndDate System.String
DATENAME(mm, EndDate) + ' ' +
DATENAME(dd, EndDate) + ', ' +
DATENAME(yy, EndDate)
SimpleStartDate System.String
DATENAME(mm, StartDate) + ' ' +
DATENAME(dd, StartDate) + ', ' +
DATENAME(yy, StartDate)
Total: 20 column(s)

Collapse image See also


About this documentation