Database reference - Adventure Works DW

MeasureGroup - Mined Customers - Internet Orders

Measure group properties

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

Measures

namedescriptioniddatatypesourceformat stringexpressionaggregate functionperspectives
Internet Order Count    Sales Order Number  Integer  #,#    DistinctCountDirect Sales 

Dimensions

nametype
Mined Customers Clustered Customersdata mining 
Mined Customers Customerregular 
Mined Customers Dateregular 
Mined Customers Delivery Dateregular 
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 

Dependency graph

Mined Customers Clustered CustomersMined Customers CustomerMined Customers DateMined Customers Delivery DateMined 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 Orders

Objects that Mined Customers Internet Orders depends on

nameobject typelevel
Mined Customers Clustered CustomersCubeDimension1
Mined Customers CustomerCubeDimension1
Mined Customers DateCubeDimension1
Mined Customers Delivery DateCubeDimension1
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