Database reference - Adventure Works DW

MeasureGroup - Adventure Works - Internet Sales

Measure group properties

namevalue
nameInternet Sales 
parent cubeAdventure Works 
description 
idFact Internet Sales 1 
typeSales 
storage modeMolap 
estimated rows60398 
estimated size (mb)2.28 
processing modeRegular 

Measures

namedescriptioniddatatypesourceformat stringexpressionaggregate functionperspectives
Internet Sales Amount    Sales Amount 2  Currency  dbo_FactInternetSales.SalesAmount  Currency  [Internet Sales Amount] / [Average Rate]  SumDirect Sales 
Internet Order Quantity    Order Quantity 2  Integer  dbo_FactInternetSales.OrderQuantity  #,#    SumDirect Sales 
Internet Extended Amount    Extended Amount 2  Currency  dbo_FactInternetSales.ExtendedAmount  Currency  [Internet Extended Amount] / [Average Rate]  SumDirect Sales 
Internet Tax Amount    Tax Amt 2  Currency  dbo_FactInternetSales.TaxAmt  Currency  [Internet Tax Amount] / [Average Rate]  SumDirect Sales 
Internet Freight Cost    Freight 2  Currency  dbo_FactInternetSales.Freight  Currency  [Internet Freight Cost] / [Average Rate]  SumDirect Sales 
Internet Unit Price    Unit Price 2  Currency  dbo_FactInternetSales.UnitPrice  Currency  [Internet Unit Price] / [Average Rate]  Sum 
Internet Total Product Cost    Total Product Cost 2  Currency  dbo_FactInternetSales.TotalProductCost  Currency  [Internet Total Product Cost] / [Average Rate]  SumDirect Sales 
Internet Standard Product Cost    Product Standard Cost 2  Currency  dbo_FactInternetSales.ProductStandardCost  Currency  [Internet Standard Product Cost] / [Average Rate]  SumDirect Sales 
Internet Transaction Count    Product Key  Integer  dbo_FactInternetSales.  #,#    Count 

Dimensions

nametype
Adventure Works Destination Currencymany to many 
Adventure Works Source Currencyregular 
Adventure Works Customerregular 
Adventure Works Productregular 
Adventure Works Promotionregular 
Adventure Works Sales Territoryregular 
Adventure Works Delivery Dateregular 
Adventure Works Internet Sales Order Detailsdegenerate 
Adventure Works Dateregular 
Adventure Works Sales Reasonmany to many 
Adventure Works Ship Dateregular 

Calculated members

namedescriptioncalculation
[Measures].[Growth in Customer Base]    MdxScript 
[Measures].[Internet Average Sales Amount]    MdxScript 
[Measures].[Internet Average Unit Price]    MdxScript 
[Measures].[Internet Gross Profit Margin]    MdxScript 
[Measures].[Internet Gross Profit]  here's a comment about a calculated member  MdxScript 
[Measures].[Internet Ratio to All Products]    MdxScript 
[Measures].[Internet Ratio to Parent Product]    MdxScript 

Partitions

namedescriptionidsourcestorage modeprocessing mode
Internet_Sales_2001    Internet_Sales_2001  Adventure Works DW..  Molap  Regular 
Internet_Sales_2002    Internet_Sales_2002  Adventure Works DW..  Molap  Regular 
Internet_Sales_2003    Internet_Sales_2003  Adventure Works DW..  Molap  Regular 
Internet_Sales_2004    Internet_Sales_2004  Adventure Works DW..  Molap  Regular 

Perspectives where visible

name
Direct Sales 

Dependency graph

Adventure WorksAdventure Works Destination CurrencyAdventure Works Dim CurrencyAdventure Works Dim CustomerAdventure Works Dim ProductAdventure Works Dim PromotionAdventure Works Dim Sales TerritoryAdventure Works Due Date Key - Dim TimeAdventure Works Internet Sales Order DetailsAdventure Works Order Date Key - Dim TimeAdventure Works Sales ReasonAdventure Works Ship Date Key - Dim TimeAdventure Works Internet SalesAggregationDesignInternet_Sales_2001Internet_Sales_2002Internet_Sales_2003Internet_Sales_2004

Objects that Adventure Works Internet Sales depends on

nameobject typelevel
Adventure Works Destination CurrencyCubeDimension1
Adventure Works Dim CurrencyCubeDimension1
Adventure Works Dim CustomerCubeDimension1
Adventure Works Dim ProductCubeDimension1
Adventure Works Dim PromotionCubeDimension1
Adventure Works Dim Sales TerritoryCubeDimension1
Adventure Works Due Date Key - Dim TimeCubeDimension1
Adventure Works Internet Sales Order DetailsCubeDimension1
Adventure Works Order Date Key - Dim TimeCubeDimension1
Adventure Works Sales ReasonCubeDimension1
Adventure Works Ship Date Key - Dim TimeCubeDimension1

Objects that depend on Adventure Works Internet Sales

nameobject typelevel
AggregationDesignAggregationDesign1
FinancePartition2
Total_Sales_2004Partition2
Total_Sales_2003Partition2
Total_Sales_2002Partition2
Total_Sales_2001Partition2
Reseller_Sales_2004Partition2
Reseller_Sales_2003Partition2
Reseller_Sales_2002Partition2
Reseller_Sales_2001Partition2
Internet_Sales_2004Partition2
Internet_Sales_2003Partition2
Internet_Sales_2002Partition2
Internet_Sales_2001Partition2



Documentation generated by SqlSpec