| Property |
Value |
| Database schema name |
dbo |
| Database table name |
DimPromotion |
| Friendly name |
Promotion |
| Table name |
dbo_DimPromotion |
| Table type |
Table |
| Is loaded |
|
| 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)
| 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)