Database reference - AmoAdventureWorks

Dimension - Customer

Dimension properties

namevalue
nameCustomer 
idCustomer 
description 
created8/26/2006 10:06:08 PM 
last schema update8/26/2006 10:06:08 PM 
loadedTrue 
last processed8/26/2006 10:06:22 PM  
stateProcessed  
typeCustomers  
language1033  
collationLatin1_General_CI_AS  
unknown member nameUnknown 
attribute all member nameAll Customers 
data source viewAdventureWorksDW 

Attributes

namedescriptionidtypeusageestimated count
Customer.City    City       
Customer.Country-Region    Country-Region       
Customer.Education    Education       
Customer.Email Address    Email Address       
Customer.Full Name    Full Name  Customers  Key   
Customer.Gender    Gender       
Customer.Marital Status    Marital Status       
Customer.Occupation    Occupation       
Customer.Phone    Phone       
Customer.Postal Code    Postal Code       
Customer.State-Province    State-Province       

Hierarchies

namedescriptionidall member name
Customer Geography    Customer Geography  All Customers 

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

AmoAdventureWorksAdventureWorksDWAdventureWorksDWCustomerAdventure WorksAdventure Works Customer
Legend
tabledatabase
cubemeasure group
data sourcedimension
role
mining structuremining model
data source viewdatabase permission

Code

Dimension.Customer.xmla



Documentation generated by SqlSpec