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