Database reference - Adventure Works DW

MeasureGroup - Mined Customers - Internet Sales

Measure group properties

namevalue
nameInternet Sales 
parent cubeMined Customers 
description 
idInternet Sales 
type 
storage modeMolap 
estimated rows 
estimated size (mb) 
processing modeRegular 

Measures

namedescriptioniddatatypesourceformat stringexpressionaggregate functionperspectives
Internet Sales Amount    Sales Amount 2  Currency  Currency  [Internet Sales Amount] / [Average Rate]  Sum 
Internet Order Quantity    Order Quantity 2  Integer  #,#    Sum 
Internet Extended Amount    Extended Amount 2  Currency  Currency  [Internet Extended Amount] / [Average Rate]  Sum 
Internet Tax Amount    Tax Amt 2  Currency  Currency  [Internet Tax Amount] / [Average Rate]  Sum 
Internet Freight Cost    Freight 2  Currency  Currency  [Internet Freight Cost] / [Average Rate]  Sum 
Internet Unit Price    Unit Price 2  Currency  Currency  [Internet Unit Price] / [Average Rate]  Sum 
Internet Total Product Cost    Total Product Cost 2  Currency  Currency  [Internet Total Product Cost] / [Average Rate]  Sum 
Internet Standard Product Cost    Product Standard Cost 2  Currency  Currency  [Internet Standard Product Cost] / [Average Rate]  Sum 
Internet Transaction Count    Product Key  Integer  #,#    Count 

Dimensions

nametype
Mined Customers Clustered Customersdata mining 
Mined Customers Customerregular 
Mined Customers Dateregular 
Mined Customers Delivery Dateregular 
Mined Customers Destination Currencymany to many 
Mined Customers Internet Sales Order Detailsdegenerate 
Mined Customers Productregular 
Mined Customers Promotionregular 
Mined Customers Sales Reasonmany to many 
Mined Customers Sales Territoryregular 
Mined Customers Ship Dateregular 
Mined Customers Source Currencyregular 
Mined Customers Subcategory Basket Analysisdata mining 

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]    MdxScript 
[Measures].[Internet Ratio to All Products]    MdxScript 
[Measures].[Internet Ratio to Parent Product]    MdxScript 

Dependency graph

Mined 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 AnalysisMined Customers Internet Sales

Objects that Mined Customers Internet Sales depends on

nameobject typelevel
Mined Customers Clustered CustomersCubeDimension1
Mined Customers CustomerCubeDimension1
Mined Customers DateCubeDimension1
Mined Customers Delivery DateCubeDimension1
Mined Customers Destination CurrencyCubeDimension1
Mined Customers Internet Sales Order DetailsCubeDimension1
Mined Customers ProductCubeDimension1
Mined Customers PromotionCubeDimension1
Mined Customers Sales ReasonCubeDimension1
Mined Customers Sales TerritoryCubeDimension1
Mined Customers Ship DateCubeDimension1
Mined Customers Source CurrencyCubeDimension1
Mined Customers Subcategory Basket AnalysisCubeDimension1



Documentation generated by SqlSpec