Dimension attribute: Reseller

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   701 
 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   Channel 
 Usage   Key 

Collapse image Key columns


Name  Data size  Data type  Format  Null processing  Trimming 
[dbo_DimReseller].[ResellerKey] -1 Integer   Automatic Right
Total: 1 key column(s)

Collapse image Attribute relationships


Name  Data size  Data type  Format  Null processing  Trimming 
Product Line Many Mandatory Strong Flexible True
Last Order Year Many Mandatory Strong Flexible True
First Order Year Many Mandatory Strong Flexible True
Year Opened Many Mandatory Strong Rigid True
Annual Revenue Many Mandatory Strong Flexible True
Min Payment Amount Many Mandatory Strong Flexible True
Min Payment Type Many Mandatory Strong Flexible True
Bank Name Many Mandatory Strong Flexible True
Annual Sales Many Mandatory Strong Flexible True
Number of Employees Many Mandatory Strong Flexible True
Business Type Many Mandatory Strong Rigid True
Phone One Mandatory Strong Flexible True
Order Frequency Many Mandatory Strong Flexible True
Order Month Many Mandatory Strong Flexible True
Geography Key Many Mandatory Strong Flexible False
Address One Mandatory Strong Flexible True
Total: 16 attribute relationship(s)

Collapse image See also


About this documentation