Dimension attribute: Customer

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   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 

Collapse image Key columns


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

Collapse image 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
Total: 16 attribute relationship(s)

Collapse image See also


About this documentation