Dimension attribute: Customer
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 | 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 |
Key columns
| Name | Data size | Data type | Format | Null processing | Trimming |
| [dbo_DimCustomer].[CustomerKey] | -1 | Integer | Automatic | Right |
Attribute relationships
| 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 |
See also