Database reference - Adventure Works DW

MiningModel - Customer Clusters

Mining model properties

namevalue
nameCustomer Clusters 
description 
idCustomer Clusters 
algorithmMicrosoft_Clustering 
allow drill throughtrue 
language1033 
collationLatin1_General_CI_AS 

Columns

nameidsource column idusage
Customer Counts 1  Customer  Customer  Key 
Commute Distance  Commute Distance  Commute Distance   
Education  Education  Education   
Gender  Gender  Gender   
Home Owner  Home Owner  Home Owner   
Marital Status  Marital Status  Marital Status   
Number of Cars Owned  Number of Cars Owned  Number of Cars Owned   
Number of Children At Home  Number of Children At Home  Number of Children At Home   
Occupation  Occupation  Occupation   
Total Children  Total Children  Total Children   
Yearly Income  Yearly Income  Yearly Income   

Dependency graph

Customer MiningCustomer ClustersClustered Customers

Objects that Customer Clusters depends on

nameobject typelevel
Customer MiningMiningStructure1
Adventure Works DWDataSourceView2
Sales Summary Order DetailsDimension2
Destination CurrencyDimension2
Sales ChannelDimension2
Internet Sales Order DetailsDimension2
Reseller Sales Order DetailsDimension2
Sales ReasonDimension2
Source CurrencyDimension2
DateDimension2
AccountDimension2
OrganizationDimension2
DepartmentDimension2
ScenarioDimension2
EmployeeDimension2
Sales TerritoryDimension2
GeographyDimension2
ProductDimension2
PromotionDimension2

Objects that depend on Customer Clusters

nameobject typelevel
Clustered CustomersDimension1
Mined Customers Clustered CustomersCubeDimension2
Mined Customers Internet CustomersMeasureGroup3
Mined Customers Internet OrdersMeasureGroup3
Mined Customers Internet SalesMeasureGroup3

Code

MiningModel.CustomerClusters.xmla



Documentation generated by SqlSpec