Table: DimProduct

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   DimProduct 
 Friendly name   Product 
 Table name   dbo_DimProduct 
 Table type   Table 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


Relation name  Child (foreign key) columns  Parent name  Parent type  Parent (primary key) columns 
FK_DimProduct_DimProductSubcategory ProductSubcategoryKey DimProductSubcategory Table ProductSubcategoryKey
DimProduct-DimProductSubcategory ProductSubcategoryKey DimProductSubcategory Table ProductSubcategoryAlternateKey
Total: 2 parent relationship(s)

Collapse image Child relations


Relation name  Parent (primary key) columns  Child name  Child type  Child (foreign key) columns 
FK_FactResellerSales_DimProduct ProductKey FactResellerSales Table ProductKey
FK_FactInternetSales_DimProduct ProductKey FactInternetSales Table ProductKey
FactSalesSummary-DimProduct ProductKey Sales Summary Facts View ProductKey
Total: 3 child relationship(s)

Collapse image Columns


Name  Type  Computed column expression 
ProductKey System.Int32  
ProductAlternateKey System.String  
ProductSubcategoryKey System.Int32  
WeightUnitMeasureCode System.String  
SizeUnitMeasureCode System.String  
EnglishProductName System.String  
SpanishProductName System.String  
FrenchProductName System.String  
StandardCost System.Decimal  
FinishedGoodsFlag System.Boolean  
Color System.String  
SafetyStockLevel System.Int16  
ReorderPoint System.Int16  
ListPrice System.Decimal  
Size System.String  
SizeRange System.String  
Weight System.Double  
DaysToManufacture System.Int32  
ProductLine System.String  
DealerPrice System.Decimal  
Class System.String  
Style System.String  
ModelName System.String  
LargePhoto System.Byte[]  
EnglishDescription System.String  
FrenchDescription System.String  
ChineseDescription System.String  
ArabicDescription System.String  
HebrewDescription System.String  
ThaiDescription System.String  
StartDate System.DateTime  
EndDate System.DateTime  
Status System.String  
ProductLineName System.String
CASE ProductLine 
    WHEN 'M' THEN 'Mountain' 
    WHEN 'R' THEN 'Road' 
    WHEN 'S' THEN 'Accessory' 
    WHEN 'T' THEN 'Touring' 
    ELSE 'Components' 
END
WeightDesc System.String
Case
    WHEN Weight IS NULL THEN 'Unknown'
    ELSE CONVERT(CHAR (5), Weight)
END
SimpleStartDate System.String
DATENAME( mm, StartDate ) + ' ' +
DATENAME( dd, StartDate ) + ', ' +
DATENAME( yy, StartDate )
SimpleEndDate System.String
CASE
    WHEN EndDate IS NULL THEN 'Active'
    ELSE
    DATENAME(mm, EndDate) + ' ' +
    DATENAME(dd, EndDate) + ', ' + 
    DATENAME(yy, EndDate)
END
StatusDesc System.String
CASE
    WHEN Status IS NULL THEN 'Historical'
    ELSE Status
END
StyleDesc System.String
CASE
    WHEN Style IS NULL THEN 'Not Applicable' 
    WHEN Style = 'U' THEN 'Unisex'
    WHEN Style = 'M' THEN 'Mens'
    WHEN Style = 'W' THEN 'Womens'   
END
ClassDesc System.String
CASE
    WHEN Class IS NULL THEN 'Not Applicable'
    WHEN Class = 'H' THEN  'High'
    WHEN Class = 'M' THEN 'Medium'
    WHEN Class = 'L' THEN 'Low'
END
GermanDescription System.String  
JapaneseDescription System.String  
TurkishDescription System.String  
ModelNameAssembly System.String
Case
    WHEN ModelName IS NULL THEN 'Assembly Components'
    ELSE ModelName
END
Total: 44 column(s)

Collapse image See also


About this documentation