Database reference - Adventure Works DW

Attribute - Product

Attribute properties

namevalue
nameProduct 
parent dimensionProduct 
description 
default member 
idProduct Name 
typeProduct 
usageKey 
estimated count395 
order byAttributeKey 
order by attribute idProductSubcategoryKey 
grouping behaviorDiscourageGrouping 
instance selectionList 
attribute hierarchy visible 
attribute hierarchy enabled 
attribute hierarchy display folder 
attribute hierarchy ordered 
attribute hierarchy optimized state 

Name column

namedatatypesize
dbo_DimProduct.EnglishProductName  WChar   

Key columns

namedatatypesize
dbo_DimProduct.ProductKey  Integer   

Attribute relationships

nameidcardinality
Model Name  Model Name   
Style  Style   
Class  Class   
Dealer Price  Dealer Price   
Days to Manufacture  Days To Manufacture   
Weight  Weight   
Size Range  Size Range   
Size  Size   
List Price  List Price   
Reorder Point  Reorder Point   
Safety Stock Level  Safety Stock Level   
Color  Color   
Standard Cost  Standard Cost   
Subcategory  ProductSubcategoryKey   
Status  Status   
Start Date  Start Date   
End Date  End Date   
Product Key  Product Alternate Key  One 
Large Photo  Large Photo   

Hierarchy levels referenced

hierarchylevel
Product Categories  Product
Stock Level  Product

Perspectives where visible

name
Direct Sales 
Channel Sales 
Sales Summary 



Documentation generated by SqlSpec