Database reference - Adventure Works DW

Cube - Mined Customers

Cube properties

namevalue
nameMined Customers 
description 
idAdventure Works DW 1 
estimated rows0 
language1033 
collationLatin1_General_CI_AS 
default measure[Measures].[Internet Sales Amount] 
data source viewAdventure Works DW 
created3/26/2009 10:44:05 PM 
last schema update2/11/2010 8:09:48 PM 
last processed2/11/2010 8:09:59 PM 
loadedTrue 
stateProcessed 

Dimensions

cube dimensiondatabase dimensionid
Mined Customers Clustered Customers  Clustered Customers  Clustered Customers 
Mined Customers Customer  Customer  Customer 
Mined Customers Date  Date  Date 
Mined Customers Delivery Date  Date  Delivery Date 
Mined Customers Destination Currency  Destination Currency  Destination Currency 
Mined Customers Internet Sales Order Details  Internet Sales Order Details  Internet Sales Order Details 
Mined Customers Product  Product  Product 
Mined Customers Promotion  Promotion  Promotion 
Mined Customers Sales Reason  Sales Reason  Sales Reason 
Mined Customers Sales Territory  Sales Territory  Sales Territory 
Mined Customers Ship Date  Date  Ship Date 
Mined Customers Source Currency  Source Currency  Source Currency 
Mined Customers Subcategory Basket Analysis  Subcategory Basket Analysis  Subcategory Basket Analysis 

Measure groups

namedescriptionidtypestateprocessing modestorage modeestimated rows
Internet Sales    Internet Sales      Regular  Molap   
Internet Orders    Internet Orders    Processed  Regular  Molap   
Internet Customers    Internet Customers      Regular  Molap   
Sales Reasons    Sales Reasons      Regular  Molap   
Exchange Rates    Exchange Rates      Regular  Molap   

Calculations

nameid
Mined Customers MdxScript  MdxScript 

Actions

nameidtypedescription
Internet Details  Drilldown to Internet Details  DrillThroughAction   

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 DWAdventure Works DWClustered CustomersSubcategory Basket AnalysisClustered CustomersCustomerDateDestination CurrencyInternet Sales Order DetailsProductPromotionSales ReasonSales TerritorySource CurrencySubcategory Basket AnalysisAdventure Works DWMined CustomersMined Customers Clustered CustomersMined Customers CustomerMined Customers DateMined Customers Delivery DateMined Customers Destination CurrencyMined Customers Internet Sales Order DetailsMined Customers ProductMined Customers PromotionMined Customers Sales ReasonMined Customers Sales TerritoryMined Customers Ship DateMined Customers Source CurrencyMined Customers Subcategory Basket Analysis

Objects that Mined Customers depends on

nameobject typelevel
Adventure Works DWDatabase1
Clustered CustomersDataSourceView1
Subcategory Basket AnalysisDataSourceView1
DateDimension1
Destination CurrencyDimension1
Internet Sales Order DetailsDimension1
ProductDimension1
PromotionDimension1
Sales ReasonDimension1
Sales TerritoryDimension1
Source CurrencyDimension1

Objects that depend on Mined Customers

nameobject typelevel
Mined Customers Clustered CustomersCubeDimension1
Mined Customers Internet CustomersMeasureGroup2
Mined Customers Internet OrdersMeasureGroup2
Mined Customers Internet SalesMeasureGroup2
Mined Customers CustomerCubeDimension1
Mined Customers DateCubeDimension1
Mined Customers Exchange RatesMeasureGroup2
Mined Customers Delivery DateCubeDimension1
Mined Customers Destination CurrencyCubeDimension1
Mined Customers Internet Sales Order DetailsCubeDimension1
Mined Customers Sales ReasonsMeasureGroup2
Mined Customers ProductCubeDimension1
Mined Customers PromotionCubeDimension1
Mined Customers Sales TerritoryCubeDimension1
Mined Customers Ship DateCubeDimension1
Mined Customers Source CurrencyCubeDimension1
Mined Customers Subcategory Basket AnalysisCubeDimension1

Code

Cube.MinedCustomers.xmla



Documentation generated by SqlSpec