Database reference - Adventure Works DW

MeasureGroup - Adventure Works - Sales Orders

Measure group properties

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

Measures

name	description	id	datatype	source	format string	expression	aggregate function	perspectives
Order Count		Sales Order Number Distinct Count	Integer	FactSalesSummary.SalesOrderNumber	#,#		DistinctCount	Sales Summary

Dimensions

name	type
Adventure Works Source Currency	regular
Adventure Works Product	regular
Adventure Works Promotion	regular
Adventure Works Sales Territory	regular
Adventure Works Delivery Date	regular
Adventure Works Date	regular
Adventure Works Sales Channel	regular
Adventure Works Sales Summary Order Details	degenerate
Adventure Works Ship Date	regular

Partitions

name	description	id	source	storage mode	processing mode
Total_Orders_2001		Total_Orders_2001	Adventure Works DW..	Molap	Regular
Total_Orders_2002		Total_Orders_2002	Adventure Works DW..	Molap	Regular
Total_Orders_2003		Total_Orders_2003	Adventure Works DW..	Molap	Regular
Total_Orders_2004		Total_Orders_2004	Adventure Works DW..	Molap	Regular

Perspectives where visible

name
Sales Summary

Dependency graph

Adventure WorksAdventure Works Dim CurrencyAdventure Works Dim ProductAdventure Works Dim PromotionAdventure Works Dim Sales TerritoryAdventure Works Due Date Key - Dim TimeAdventure Works Order Date Key - Dim TimeAdventure Works Sales ChannelAdventure Works Sales Summary Order DetailsAdventure Works Ship Date Key - Dim TimeAdventure Works Sales Orders Total_Orders_2001Total_Orders_2002Total_Orders_2003Total_Orders_2004

Objects that Adventure Works Sales Orders depends on

name	object type	level
Adventure Works Dim Currency	CubeDimension	1
Adventure Works Dim Product	CubeDimension	1
Adventure Works Dim Promotion	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 Sales Channel	CubeDimension	1
Adventure Works Sales Summary Order Details	CubeDimension	1
Adventure Works Ship Date Key - Dim Time	CubeDimension	1

Objects that depend on Adventure Works Sales Orders

name	object type	level
Total_Orders_2001	Partition	1
Total_Orders_2002	Partition	1
Total_Orders_2003	Partition	1
Total_Orders_2004	Partition	1

Documentation generated by SqlSpec