Dimension attribute: Customer
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 | 18484 |
Grouping behavior | DiscourageGrouping |
Instance selection | MandatoryFilter |
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 | Customers |
Usage | Key |
Name | Data size | Data type | Format | Null processing | Trimming |
[dbo_DimCustomer].[CustomerKey] | -1 | Integer | Automatic | Right |
Name | Data size | Data type | Format | Null processing | Trimming |
Date of First Purchase | Many | Mandatory | Strong | Flexible | True |
Phone | Many | Mandatory | Strong | Flexible | True |
Number of Cars Owned | Many | Mandatory | Strong | Flexible | True |
Occupation | Many | Mandatory | Strong | Flexible | True |
Education | Many | Mandatory | Strong | Flexible | True |
Number of Children At Home | Many | Mandatory | Strong | Flexible | True |
Total Children | Many | Mandatory | Strong | Flexible | True |
Yearly Income | Many | Mandatory | Strong | Flexible | True |
Email Address | One | Mandatory | Strong | Flexible | True |
Birth Date | Many | Mandatory | Strong | Rigid | True |
Marital Status | Many | Mandatory | Strong | Flexible | True |
Gender | Many | Mandatory | Strong | Rigid | True |
Home Owner | Many | Mandatory | Strong | Flexible | True |
Commute Distance | Many | Mandatory | Strong | Flexible | True |
Postal Code | Many | Mandatory | Strong | Flexible | True |
Address | One | Mandatory | Strong | Flexible | True |