Database reference - AmoAdventureWorks

Cube - Adventure Works

Cube properties

namevalue
nameAdventure Works 
description 
idAdventure Works 
estimated rows0 
language1033 
collationLatin1_General_CI_AS 
default measure[Reseller Sales Amount] 
data source viewAdventureWorksDW 
created8/26/2006 10:06:13 PM 
last schema update8/26/2006 10:06:13 PM 
last processed8/26/2006 10:06:31 PM 
loadedTrue 
stateProcessed 

Dimensions

cube dimensiondatabase dimensionid
Adventure Works Customer  Customer  Customer 
Adventure Works Date  Date  Order Date Key - Dim Time 
Adventure Works Delivery Date  Date  Delivery Date Key - Dim Time 
Adventure Works Internet Sales Order Details  Internet Sales Order Details  Internet Sales Order Details 
Adventure Works Product  Product  Product 
Adventure Works Reseller  Reseller  Reseller 
Adventure Works Reseller Geography  Geography  Geography 
Adventure Works Reseller Sales Order Details  Reseller Sales Order Details  Reseller Sales Order Details 
Adventure Works Sales Reason  Sales Reason  Sales Reason 
Adventure Works Ship Date  Date  Ship Date Key - Dim Time 
Adventure Works Source Currency  Currency  Currency 

Measure groups

namedescriptionidtypestateprocessing modestorage modeestimated rows
Adventure Works.Sales Reasons    Sales Reasons    Processed  LazyAggregations  Molap   
Adventure Works.Internet Sales    Internet Sales  Sales  Processed  LazyAggregations  Molap   
Adventure Works.Reseller Sales    Reseller Sales  Sales  Processed  LazyAggregations  Molap   
Adventure Works.Customers    Customers    Processed  LazyAggregations  Molap   
Adventure Works.Currency Rates    Currency Rates  ExchangeRate  Processed  LazyAggregations  Molap   

Cube permissions

nameidrolereadwrite
Adventure Works.CubePermission  CubePermission  Processors  Allowed   
Adventure Works.CubePermission 1  CubePermission 1  Writers  Allowed  Allowed 
Adventure Works.CubePermission 2  CubePermission 2  Readers  Allowed   

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

AmoAdventureWorksAdventureWorksDWCurrencyCustomerDateGeographyInternet Sales Order DetailsProductResellerReseller Sales Order DetailsSales ReasonAdventureWorksDWAdventure WorksAdventure Works CustomerAdventure Works DateAdventure Works Delivery DateAdventure Works Internet Sales Order DetailsAdventure Works ProductAdventure Works ResellerAdventure Works Reseller GeographyAdventure Works Reseller Sales Order DetailsAdventure Works Sales ReasonAdventure Works Ship DateAdventure Works Source CurrencyAdventure Works CubePermissionAdventure Works CubePermission 1Adventure Works CubePermission 2Adventure Works Currency RatesAdventure Works CustomersAdventure Works Internet SalesAdventure Works Reseller SalesAdventure Works Sales Reasons
Legend
tabledatabase
cubemeasure group
data sourcedimension
role
mining structuremining model
data source viewdatabase permission

Code

Cube.AdventureWorks.xmla



Documentation generated by SqlSpec