Dimension attribute: Product

CollapseAll image

Collapse image Attribute properties


Name  Value 
 Attribute hierarchy enabled   True 
 Attribute hierarchy optimized state   FullyOptimized 
 Attribute hierarchy ordered   True 
 Attribute hierarchy processing state   Unprocessed 
 Attribute hierarchy display folder    
 Attribute hierarchy visible   True 
 Discretization bucket count   0 
 Discretization method   None 
 Estimated count   395 
 Grouping behavior   DiscourageGrouping 
 Instance selection   List 
 Is aggregatable   True 
 Key uniqueness guarantee   False 
 Member names unique   False 
 Members with data   NonLeafDataVisible 
 Order by   Name 
 Order by attribute   / 
 Processing state   Unprocessed 
 Root member if   ParentIsBlankSelfOrMissing 
 Type   Product 
 Usage   Key 

Collapse image Key columns


Name  Data size  Data type  Format  Null processing  Trimming 
[dbo_DimProduct].[ProductKey] 0 Integer   Automatic Right
Total: 1 key column(s)

Collapse image Attribute relationships


Name  Data size  Data type  Format  Null processing  Trimming 
Model Name Many Mandatory Strong Flexible True
Style Many Mandatory Strong Flexible True
Class Many Mandatory Strong Flexible True
Dealer Price Many Mandatory Strong Flexible True
Days to Manufacture Many Mandatory Strong Flexible True
Weight Many Mandatory Strong Flexible True
Size Range Many Mandatory Strong Flexible True
Size Many Mandatory Strong Flexible True
List Price Many Mandatory Strong Flexible True
Reorder Point Many Mandatory Strong Flexible True
Safety Stock Level Many Mandatory Strong Flexible True
Color Many Mandatory Strong Flexible True
Standard Cost Many Mandatory Strong Flexible True
Status Many Mandatory Strong Flexible True
Start Date Many Mandatory Strong Flexible True
End Date Many Mandatory Strong Flexible True
Large Photo Many Mandatory Strong Flexible True
Subcategory Many Mandatory Strong Rigid True
Total: 18 attribute relationship(s)

Collapse image See also


About this documentation