Database reference - Adventure Works DW

Dimension - Clustered Customers

Dimension properties

namevalue
nameClustered Customers 
idClustered Customers 
description 
created3/26/2009 10:43:58 PM 
last schema update2/11/2010 8:09:39 PM 
loadedTrue 
last processed3/26/2009 10:49:52 PM 
stateProcessed 
type 
language1033 
collationLatin1_General_CI_AS 
unknown member nameUnknown 
attribute all member nameAll Customer Clusters 
data source viewClustered Customers 

Attributes

namedescriptiondefault memberidtypeusageestimated counthierarchiesperspectives
Attribute Name      ATTRIBUTE_NAME           
Customer Clusters      PARENT_UNIQUE_NAME    Parent       
Node Unique Name      NODE_UNIQUE_NAME    Key       

Proactive caching properties

namevalue
silence interval-PT1S 
latency-PT1S 
silence override interval-PT1S 
force rebuild interval-PT1S 
aggregation storage 
online mode 
source typeProactiveCachingInheritedBinding 
source notification technique 

Dependency graph

Adventure Works DWClustered CustomersCustomer ClustersClustered CustomersMined CustomersMined Customers Clustered Customers

Objects that Clustered Customers depends on

nameobject typelevel
Adventure Works DWDatabase1
Customer ClustersMiningModel1
Customer MiningMiningStructure2
Sales Summary Order DetailsDimension3
Destination CurrencyDimension3
Sales ChannelDimension3
Internet Sales Order DetailsDimension3
Reseller Sales Order DetailsDimension3
Sales ReasonDimension3
Source CurrencyDimension3
DateDimension3
AccountDimension3
OrganizationDimension3
DepartmentDimension3
ScenarioDimension3
EmployeeDimension3
Sales TerritoryDimension3
GeographyDimension3
ProductDimension3
PromotionDimension3

Objects that depend on Clustered Customers

nameobject typelevel
Mined CustomersCube1
Mined Customers Internet Sales Order DetailsCubeDimension2
Mined Customers Sales ReasonsMeasureGroup3
Mined Customers Internet CustomersMeasureGroup3
Mined Customers Internet OrdersMeasureGroup3
Mined Customers Subcategory Basket AnalysisCubeDimension2
Mined Customers Clustered CustomersCubeDimension2
Mined Customers Destination CurrencyCubeDimension2
Mined Customers Exchange RatesMeasureGroup3
Mined Customers Source CurrencyCubeDimension2
Mined Customers Sales TerritoryCubeDimension2
Mined Customers CustomerCubeDimension2
Mined Customers PromotionCubeDimension2
Mined Customers ProductCubeDimension2
Mined Customers Delivery DateCubeDimension2
Mined Customers Ship DateCubeDimension2
Mined Customers DateCubeDimension2

Code

Dimension.ClusteredCustomers.xmla



Documentation generated by SqlSpec