Database reference - Adventure Works DW

MeasureGroup - Adventure Works - Reseller Orders

Measure group properties

name	value
name	Reseller Orders
parent cube	Adventure Works
description
id	Reseller Orders
type
storage mode	Molap
estimated rows
estimated size (mb)	1.24
processing mode	Regular

Measures

name	description	id	datatype	source	format string	expression	aggregate function	perspectives
Reseller Order Count		Sales Order Number 1	Integer	dbo_FactResellerSales.SalesOrderNumber	#,#		DistinctCount	Channel Sales, Sales Targets

Dimensions

name	type
Adventure Works Source Currency	regular
Adventure Works Employee	regular
Adventure Works Geography	reference
Adventure Works Product	regular
Adventure Works Promotion	regular
Adventure Works Reseller	regular
Adventure Works Sales Territory	regular
Adventure Works Delivery Date	regular
Adventure Works Date	regular
Adventure Works Reseller Sales Order Details	degenerate
Adventure Works Ship Date	regular

Partitions

name	description	id	source	storage mode	processing mode
Reseller_Orders_2001		Reseller_Orders_2001	Adventure Works DW..	Molap	Regular
Reseller_Orders_2002		Reseller_Orders_2002	Adventure Works DW..	Molap	Regular
Reseller_Orders_2003		Reseller_Orders_2003	Adventure Works DW..	Molap	Regular
Reseller_Orders_2004		Reseller_Orders_2004	Adventure Works DW..	Molap	Regular

Perspectives where visible

name
Channel Sales
Sales Targets

Dependency graph

Adventure WorksAdventure Works Dim CurrencyAdventure Works Dim EmployeeAdventure Works Dim GeographyAdventure Works Dim ProductAdventure Works Dim PromotionAdventure Works Dim ResellerAdventure Works Dim Sales TerritoryAdventure Works Due Date Key - Dim TimeAdventure Works Order Date Key - Dim TimeAdventure Works Reseller Sales Order DetailsAdventure Works Ship Date Key - Dim TimeAdventure Works Reseller Orders Reseller_Orders_2001Reseller_Orders_2002Reseller_Orders_2003Reseller_Orders_2004

Objects that Adventure Works Reseller Orders depends on

name	object type	level
Adventure Works Dim Currency	CubeDimension	1
Adventure Works Dim Employee	CubeDimension	1
Adventure Works Dim Geography	CubeDimension	1
Adventure Works Dim Product	CubeDimension	1
Adventure Works Dim Promotion	CubeDimension	1
Adventure Works Dim Reseller	CubeDimension	1
Adventure Works Dim Sales Territory	CubeDimension	1
Adventure Works Due Date Key - Dim Time	CubeDimension	1
Adventure Works Order Date Key - Dim Time	CubeDimension	1
Adventure Works Reseller Sales Order Details	CubeDimension	1
Adventure Works Ship Date Key - Dim Time	CubeDimension	1

Objects that depend on Adventure Works Reseller Orders

name	object type	level
Reseller_Orders_2001	Partition	1
Reseller_Orders_2002	Partition	1
Reseller_Orders_2003	Partition	1
Reseller_Orders_2004	Partition	1

Documentation generated by SqlSpec