Adventure Works DW - Dimension

Dimension properties

name	value
name	Product
id	Dim Product
description
created	3/26/2009 10:43:57 PM
last schema update	2/11/2010 8:09:37 PM
loaded	True
last processed	3/26/2009 10:48:46 PM
state	Processed
type	Products
language	1033
collation	Latin1_General_CI_AS
unknown member name	Unknown Products
attribute all member name	All Products
data source view	Adventure Works DW

Attributes

name	id	type	usage	estimated count	hierarchies
Category	Product Category Name	ProductCategory		4	Product Model Categories, Product Categories
Class	Class
Color	Color
Days to Manufacture	Days To Manufacture			4	Manufacture Time
Dealer Price	Dealer Price
End Date	End Date	ScdEndDate
Large Photo	Large Photo
List Price	List Price
Model Name	Model Name			119	Product Model Categories, Product Model Lines
Product	Product Name	Product	Key	395	Product Categories, Stock Level
Product Key	Product Alternate Key
Product Line	ProductLineDesc			4	Product Model Lines
Reorder Point	Reorder Point
Safety Stock Level	Safety Stock Level			6	Stock Level
Size	Size
Size Range	Size Range
Standard Cost	Standard Cost
Start Date	Start Date	ScdStartDate
Status	Status	ScdStatus
Style	Style
Subcategory	ProductSubcategoryKey			37	Product Model Categories, Product Categories, Manufacture Time
Weight	Weight

Hierarchies

name	id	all member name
Product Model Categories	Hierarchy	All Products
Product Categories	Hierarchy 2	All Products
Manufacture Time	Hierarchy 3	All Products
Product Model Lines	Hierarchy 1	All Products
Stock Level	Hierarchy 1 1	All Products

Proactive caching properties

name	value
silence interval	-PT1S
latency	-PT1S
silence override interval	-PT1S
force rebuild interval	-PT1S
aggregation storage
online mode
source type	ProactiveCachingInheritedBinding
source notification technique

Dependency graph

Adventure Works DWAdventure Works DWAdventure Works DWProduct Adventure WorksMined CustomersAdventure Works ProductMined Customers ProductCustomer Mining

Objects that Product depends on

name	object type	level
Adventure Works DW	Database	1

Objects that depend on Product

name	object type	level
Adventure Works	Cube	1
Adventure Works Scenario	CubeDimension	2
Adventure Works Account	CubeDimension	2
Adventure Works Department	CubeDimension	2
Adventure Works Organization	CubeDimension	2
Adventure Works Sales Channel	CubeDimension	2
Adventure Works Sales Orders	MeasureGroup	3
Total_Orders_2004	Partition	4
Total_Orders_2003	Partition	4
Total_Orders_2002	Partition	4
Total_Orders_2001	Partition	4
Adventure Works Sales Summary	MeasureGroup	3
Total_Sales_2004	Partition	4
Total_Sales_2003	Partition	4
Total_Sales_2002	Partition	4
Total_Sales_2001	Partition	4
Adventure Works Destination Currency	CubeDimension	2
Adventure Works Exchange Rates	MeasureGroup	3
Currency_Rates	Partition	4
Adventure Works Financial Reporting	MeasureGroup	3
Finance	Partition	4
Adventure Works Reseller Sales	MeasureGroup	3
Reseller_Sales_2004	Partition	4
Reseller_Sales_2003	Partition	4
Reseller_Sales_2002	Partition	4
Reseller_Sales_2001	Partition	4
Adventure Works Internet Sales	MeasureGroup	3
AggregationDesign	AggregationDesign	4
Internet_Sales_2004	Partition	5
Internet_Sales_2003	Partition	5
Internet_Sales_2002	Partition	5
Internet_Sales_2001	Partition	5
Adventure Works Source Currency	CubeDimension	2
Adventure Works Sales Summary Order Details	CubeDimension	2
Adventure Works Reseller Sales Order Details	CubeDimension	2
Adventure Works Reseller Orders	MeasureGroup	3
Reseller_Orders_2004	Partition	4
Reseller_Orders_2003	Partition	4
Reseller_Orders_2002	Partition	4
Reseller_Orders_2001	Partition	4
Adventure Works Internet Sales Order Details	CubeDimension	2
Adventure Works Sales Reasons	MeasureGroup	3
Internet_Sales_Reasons	Partition	4
Adventure Works Internet Customers	MeasureGroup	3
Customers_2004	Partition	4
Customers_2003	Partition	4
Customers_2002	Partition	4
Customers_2001	Partition	4
Adventure Works Internet Orders	MeasureGroup	3
Internet_Orders_2004	Partition	4
Internet_Orders_2003	Partition	4
Internet_Orders_2002	Partition	4
Internet_Orders_2001	Partition	4
Adventure Works Sales Territory	CubeDimension	2
Adventure Works Product	CubeDimension	2
Adventure Works Promotion	CubeDimension	2
Adventure Works Employee	CubeDimension	2
Adventure Works Geography	CubeDimension	2
Adventure Works Customer	CubeDimension	2
Adventure Works Delivery Date	CubeDimension	2
Adventure Works Ship Date	CubeDimension	2
Adventure Works Date	CubeDimension	2
MdxScript	MdxScript	2
Adventure Works Sales Targets	MeasureGroup	2
Sales_Quotas	Partition	3
Channel Sales	Perspective	2
Direct Sales	Perspective	2
Adventure Works CubePermission 1	CubePermission	2
Customer Mining	MiningStructure	2
Subcategory Associations	MiningModel	3
Subcategory Basket Analysis	Dimension	4
Mined Customers Subcategory Basket Analysis	CubeDimension	5
Mined Customers Internet Customers	MeasureGroup	6
Mined Customers Internet Orders	MeasureGroup	6
Mined Customers Internet Sales	MeasureGroup	6
Customer Clusters	MiningModel	3
Clustered Customers	Dimension	4
Mined Customers Clustered Customers	CubeDimension	5
Mined Customers Product	CubeDimension	1

Code

Dimension.Product.xmla

Dimension - Product

Dimension properties

Attributes

Hierarchies

Proactive caching properties

Dependency graph

Objects that Product depends on

Objects that depend on Product

Code