Database reference - Adventure Works DW

Cube - Adventure Works

Cube properties

namevalue
nameAdventure Works 
description 
idAdventure Works DW 
estimated rows0 
language1033 
collationLatin1_General_CI_AS 
default measure[Measures].[Reseller Sales Amount] 
data source viewAdventure Works DW 
created3/26/2009 10:43:58 PM 
last schema update2/11/2010 8:09:39 PM 
last processed3/26/2009 10:49:28 PM 
loadedTrue 
stateProcessed 

Dimensions

cube dimensiondatabase dimensionid
Adventure Works Account  Account  Dim Account 
Adventure Works Customer  Customer  Dim Customer 
Adventure Works Date  Date  Order Date Key - Dim Time 
Adventure Works Delivery Date  Date  Due Date Key - Dim Time 
Adventure Works Department  Department  Dim Department Group 
Adventure Works Destination Currency  Destination Currency  Destination Currency 
Adventure Works Employee  Employee  Dim Employee 
Adventure Works Geography  Geography  Dim Geography 
Adventure Works Internet Sales Order Details  Internet Sales Order Details  Internet Sales Order Details 
Adventure Works Organization  Organization  Dim Organization 
Adventure Works Product  Product  Dim Product 
Adventure Works Promotion  Promotion  Dim Promotion 
Adventure Works Reseller  Reseller  Dim Reseller 
Adventure Works Reseller Sales Order Details  Reseller Sales Order Details  Reseller Sales Order Details 
Adventure Works Sales Channel  Sales Channel  Sales Channel 
Adventure Works Sales Reason  Sales Reason  Sales Reason 
Adventure Works Sales Summary Order Details  Sales Summary Order Details  Sales Summary Order Details 
Adventure Works Sales Territory  Sales Territory  Dim Sales Territory 
Adventure Works Scenario  Scenario  Dim Scenario 
Adventure Works Ship Date  Date  Ship Date Key - Dim Time 
Adventure Works Source Currency  Source Currency  Dim Currency 

Measure groups

namedescriptionidtypestateprocessing modestorage modeestimated rows
Internet Sales    Fact Internet Sales 1  Sales  Processed  Regular  Molap  60398 
Internet Orders    Internet Orders    Processed  Regular  Molap   
Internet Customers    Fact Internet Sales    Processed  Regular  Molap   
Sales Reasons    Fact Internet Sales Reason    Processed  Regular  Molap   
Reseller Sales    Fact Reseller Sales  Sales  Processed  Regular  Molap  60855 
Reseller Orders    Reseller Orders    Processed  Regular  Molap   
Sales Summary    Fact Sales Summary  Sales  Processed  Regular  Molap  121253 
Sales Orders    Sales Summary    Processed  Regular  Molap   
Sales Targets    Fact Sales Quota    Processed  Regular  Molap   
Financial Reporting    Fact Finance  FinancialReporting  Processed  Regular  Molap  39409 
Exchange Rates    Fact Currency Rate  ExchangeRate  Processed  Regular  Molap   

Perspectives

namedescriptionid
Direct Sales    Perspective 
Channel Sales    Perspective 1 
Sales Summary    Perspective 2 
Finance    Perspective 3 
Sales Targets    Perspective 4 

Calculations

nameid
Adventure Works MdxScript  MdxScript 

Kpis

nameiddescriptionmeasure groupvalue
Adventure WorksGrowth in Customer Base  KPI 5  The ratio between the customer count in the current period to that of the previous period.  Internet Sales  [Measures].[Growth in Customer Base] 
Adventure WorksNet Income  KPI 12  Total earnings less operating expenses, taxes, interest, depreciation and other expenses.  Financial Reporting  // Account 47 = Net Income | Scenario 1 = Actual ( [Account].[Accounts].&[47], [Scenario].[Scenario].&[1], [Measures].[Amount] )  
Adventure WorksOperating Profit  KPI 6  The difference between revenue and total operating expenses.  Financial Reporting  // Account 48 = Operating Profit | Scenario 1 = Actual ( [Account].[Accounts].&[48], [Scenario].[Scenario].&[1], [Measures].[Amount] ) 
Adventure WorksOperating Expenses  KPI 8  Business expenses not directly associated with the manufacture of a product or provision of a service.  Financial Reporting  // Account 58 = Operating Profit | Scenario 1 = Actual ( [Account].[Accounts].&[58], [Scenario].[Scenario].&[1], [Measures].[Amount] ) 
Adventure WorksFinancial Gross Margin  KPI 7  The percentage of every dollar earned that can be used to pay general and administrative expenses.  Financial Reporting  // Account 49 = Gross Margin | Scenario 1 = Actual ( [Account].[Accounts].&[49], [Scenario].[Scenario].&[1], [Measures].[Amount] ) 
Adventure WorksReturn on Assets  Return On Assets  Net income divided by assets. This is an indicator of the profitability and efficiency of a business, and its ability to leverage its assets to generate income.  Financial Reporting  // Account 47 = Net Income | Scenario 1 = Actual | Account 2 = Assets ( [Account].[Accounts].&[47], [Scenario].[Scenario].&[1], [Measures].[Amount] ) / ( [Account].[Accounts].&[2], [Scenario].[Scenario].&[1], [Measures].[Amount] )  
Adventure WorksProduct Gross Profit Margin  KPI  Total profit earned as a percentage of sales.  Sales Summary  [Measures].[Gross Profit Margin] 
Adventure WorksFinancial Variance  KPI 4  The difference between actual and budgeted values for a given account.  Financial Reporting  ( [Scenario].[Scenario].[Scenario].[Budget Variance %], [Measures].[Amount] ) 
Adventure WorksExpense to Revenue Ratio  KPI 1  The ratio of operating expenses to gross sales.  Sales Summary  [Measures].[Expense to Revenue Ratio] 
Adventure WorksRevenue  KPI 10  Total revenue from operations.  Sales Summary  [Measures].[Sales Amount] 
Adventure WorksChannel Revenue  KPI 3  Revenue realized through the reseller sales channel.  Reseller Sales  [Measures].[Reseller Sales Amount] 
Adventure WorksInternet Revenue  KPI 11  Revenue realized through direct sales via the internet.  Internet Sales  [Measures].[Internet Sales Amount] 

Actions

nameidtypedescription
City Map  Action  StandardAction  This action will display the map for a given city. 
Sales Reason Comparisons  Report Action  ReportAction  This action will launch a report comparing sales reasons for a given product category. 
Reseller Details  Drillthrough Action  DrillThroughAction   
Internet Details  Drillthrough Action 1  DrillThroughAction   
Finance Details  Drillthrough Action 2  DrillThroughAction   
Sales Quota Details  Drillthrough Action 3  DrillThroughAction   
Sales Summary Details  Drillthrough Action 4  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 DWAccountCustomerDateDepartmentDestination CurrencyEmployeeGeographyInternet Sales Order DetailsOrganizationProductPromotionResellerReseller Sales Order DetailsSales ChannelSales ReasonSales Summary Order DetailsSales TerritoryScenarioSource CurrencyAdventure Works DWAdventure WorksAdventure Works AccountAdventure Works CustomerAdventure Works DateAdventure Works Delivery DateAdventure Works DepartmentAdventure Works Destination CurrencyAdventure Works EmployeeAdventure Works GeographyAdventure Works Internet Sales Order DetailsAdventure Works OrganizationAdventure Works ProductAdventure Works PromotionAdventure Works ResellerAdventure Works Reseller Sales Order DetailsAdventure Works Sales ChannelAdventure Works Sales ReasonAdventure Works Sales Summary Order DetailsAdventure Works Sales TerritoryAdventure Works ScenarioAdventure Works Ship DateAdventure Works Source CurrencyAdventure Works CubePermissionAdventure Works CubePermission 1MdxScriptAdventure Works Exchange RatesAdventure Works Financial ReportingAdventure Works Internet CustomersAdventure Works Internet OrdersAdventure Works Internet SalesAdventure Works Reseller OrdersAdventure Works Reseller SalesAdventure Works Sales OrdersAdventure Works Sales ReasonsAdventure Works Sales SummaryAdventure Works Sales TargetsCustomer MiningChannel SalesDirect SalesFinanceSales SummarySales Targets

Objects that Adventure Works depends on

nameobject typelevel
Adventure Works DWDatabase1
AccountDimension1
CustomerDimension1
DateDimension1
DepartmentDimension1
Destination CurrencyDimension1
EmployeeDimension1
GeographyDimension1
Internet Sales Order DetailsDimension1
OrganizationDimension1
ProductDimension1
PromotionDimension1
ResellerDimension1
Reseller Sales Order DetailsDimension1
Sales ChannelDimension1
Sales ReasonDimension1
Sales Summary Order DetailsDimension1
Sales TerritoryDimension1
ScenarioDimension1
Source CurrencyDimension1

Objects that depend on Adventure Works

nameobject typelevel
Adventure Works AccountCubeDimension1
Adventure Works CustomerCubeDimension1
Adventure Works DateCubeDimension1
Adventure Works Delivery DateCubeDimension1
Adventure Works DepartmentCubeDimension1
Adventure Works Destination CurrencyCubeDimension1
Adventure Works Exchange RatesMeasureGroup2
Currency_RatesPartition3
Adventure Works Financial ReportingMeasureGroup2
FinancePartition3
Adventure Works Sales SummaryMeasureGroup2
Total_Sales_2004Partition3
Total_Sales_2003Partition3
Total_Sales_2002Partition3
Total_Sales_2001Partition3
Adventure Works Reseller SalesMeasureGroup2
Reseller_Sales_2004Partition3
Reseller_Sales_2003Partition3
Reseller_Sales_2002Partition3
Reseller_Sales_2001Partition3
Adventure Works Internet SalesMeasureGroup2
AggregationDesignAggregationDesign3
Internet_Sales_2004Partition4
Internet_Sales_2003Partition4
Internet_Sales_2002Partition4
Internet_Sales_2001Partition4
Adventure Works EmployeeCubeDimension1
Adventure Works GeographyCubeDimension1
Adventure Works Internet Sales Order DetailsCubeDimension1
Adventure Works Sales ReasonsMeasureGroup2
Internet_Sales_ReasonsPartition3
Adventure Works Internet CustomersMeasureGroup2
Customers_2004Partition3
Customers_2003Partition3
Customers_2002Partition3
Customers_2001Partition3
Adventure Works Internet OrdersMeasureGroup2
Internet_Orders_2004Partition3
Internet_Orders_2003Partition3
Internet_Orders_2002Partition3
Internet_Orders_2001Partition3
Adventure Works OrganizationCubeDimension1
Adventure Works ProductCubeDimension1
Adventure Works PromotionCubeDimension1
Adventure Works Reseller Sales Order DetailsCubeDimension1
Adventure Works Reseller OrdersMeasureGroup2
Reseller_Orders_2004Partition3
Reseller_Orders_2003Partition3
Reseller_Orders_2002Partition3
Reseller_Orders_2001Partition3
Adventure Works Sales ChannelCubeDimension1
Adventure Works Sales OrdersMeasureGroup2
Total_Orders_2004Partition3
Total_Orders_2003Partition3
Total_Orders_2002Partition3
Total_Orders_2001Partition3
Adventure Works Sales Summary Order DetailsCubeDimension1
Adventure Works Sales TerritoryCubeDimension1
Adventure Works ScenarioCubeDimension1
Adventure Works Ship DateCubeDimension1
Adventure Works Source CurrencyCubeDimension1
Adventure Works CubePermissionCubePermission1
Adventure Works CubePermission 1CubePermission1
MdxScriptMdxScript1
Adventure Works Sales TargetsMeasureGroup1
Sales_QuotasPartition2
Customer MiningMiningStructure1
Subcategory AssociationsMiningModel2
Subcategory Basket AnalysisDimension3
Mined Customers Subcategory Basket AnalysisCubeDimension4
Mined Customers Internet CustomersMeasureGroup5
Mined Customers Internet OrdersMeasureGroup5
Mined Customers Internet SalesMeasureGroup5
Customer ClustersMiningModel2
Clustered CustomersDimension3
Mined Customers Clustered CustomersCubeDimension4
Channel SalesPerspective1
Direct SalesPerspective1

Code

Cube.AdventureWorks.xmla



Documentation generated by SqlSpec