Dimension attribute: Reseller
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 |
Key columns
| Name | Data size | Data type | Format | Null processing | Trimming |
| [dbo_DimReseller].[ResellerKey] | -1 | Integer | Automatic | Right |
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 |
See also