Database reference - Adventure Works DW

MeasureGroup - Mined Customers - Internet Sales

Measure group properties

name	value
name	Internet Sales
parent cube	Mined Customers
description
id	Internet Sales
type
storage mode	Molap
estimated rows
estimated size (mb)
processing mode	Regular

Measures

name	description	id	datatype	source	format string	expression	aggregate function	perspectives
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

name	type
Mined Customers Clustered Customers	data mining
Mined Customers Customer	regular
Mined Customers Date	regular
Mined Customers Delivery Date	regular
Mined Customers Destination Currency	many to many
Mined Customers Internet Sales Order Details	degenerate
Mined Customers Product	regular
Mined Customers Promotion	regular
Mined Customers Sales Reason	many to many
Mined Customers Sales Territory	regular
Mined Customers Ship Date	regular
Mined Customers Source Currency	regular
Mined Customers Subcategory Basket Analysis	data mining

Calculated members

name	description	calculation
[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

name	object type	level
Mined Customers Clustered Customers	CubeDimension	1
Mined Customers Customer	CubeDimension	1
Mined Customers Date	CubeDimension	1
Mined Customers Delivery Date	CubeDimension	1
Mined Customers Destination Currency	CubeDimension	1
Mined Customers Internet Sales Order Details	CubeDimension	1
Mined Customers Product	CubeDimension	1
Mined Customers Promotion	CubeDimension	1
Mined Customers Sales Reason	CubeDimension	1
Mined Customers Sales Territory	CubeDimension	1
Mined Customers Ship Date	CubeDimension	1
Mined Customers Source Currency	CubeDimension	1
Mined Customers Subcategory Basket Analysis	CubeDimension	1

Documentation generated by SqlSpec