Database reference - Adventure Works DW

MeasureGroup - Adventure Works - Internet Customers

Measure group properties

namevalue
nameInternet Customers 
parent cubeAdventure Works 
description 
idFact Internet Sales 
type 
storage modeMolap 
estimated rows 
estimated size (mb)1.17 
processing modeRegular 

Measures

namedescriptioniddatatypesourceformat stringexpressionaggregate functionperspectives
Customer Count    Customer Key  Integer  dbo_FactInternetSales.CustomerKey  #,#    DistinctCountDirect Sales 

Dimensions

nametype
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 

Partitions

namedescriptionidsourcestorage modeprocessing mode
Customers_2001    Customers_2001  Adventure Works DW..  Molap  Regular 
Customers_2002    Customers_2002  Adventure Works DW..  Molap  Regular 
Customers_2003    Customers_2003  Adventure Works DW..  Molap  Regular 
Customers_2004    Customers_2004  Adventure Works DW..  Molap  Regular 

Perspectives where visible

name
Direct Sales 

Dependency graph

Adventure WorksAdventure 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 CustomersCustomers_2001Customers_2002Customers_2003Customers_2004

Objects that Adventure Works Internet Customers depends on

nameobject typelevel
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 Customers

nameobject typelevel
Customers_2001Partition1
Customers_2002Partition1
Customers_2003Partition1
Customers_2004Partition1



Documentation generated by SqlSpec