Database overview

Documentation

Documentation generated on: 9/15/2011 7:52:33 PM

Estimated size: 49.82 mb

A Unified Dimensional Model that encompasses the Adventure Works data warehouse.

Summary

type	count
data sources	1
data source views	3
cubes	2
dimensions	21
mining structures	5
roles	3
assemblies	0

Database properties

name	value
name	Adventure Works DW
ID	Adventure Works DW
created	3/26/2009 10:43:57 PM
state	Processed
last schema update	2/11/2010 8:09:28 PM
last processed	2/11/2010 8:09:59 PM
loaded	True
collation	Latin1_General_CI_AS
language	1033
data source impersonation mode	Default

Server properties

name	value
name	SPRING\KATMAI
product name	Microsoft SQL Server code name "Katmai" Analysis Services
edition	Developer
product level	SP2
version	10.0.4000.0

Dependency graph

Objects that depend on Adventure Works DW

name	object type	level
Mined Customers	Cube	1
Mined Customers Internet Sales Order Details	CubeDimension	2
Mined Customers Sales Reasons	MeasureGroup	3
Mined Customers Internet Customers	MeasureGroup	3
Mined Customers Internet Orders	MeasureGroup	3
Mined Customers Subcategory Basket Analysis	CubeDimension	2
Mined Customers Clustered Customers	CubeDimension	2
Mined Customers Destination Currency	CubeDimension	2
Mined Customers Exchange Rates	MeasureGroup	3
Mined Customers Source Currency	CubeDimension	2
Mined Customers Sales Territory	CubeDimension	2
Mined Customers Customer	CubeDimension	2
Mined Customers Promotion	CubeDimension	2
Mined Customers Product	CubeDimension	2
Mined Customers Delivery Date	CubeDimension	2
Mined Customers Ship Date	CubeDimension	2
Mined Customers Date	CubeDimension	2
DatabasePermission	DatabasePermission	1
DatabasePermission 1	DatabasePermission	1
DatabasePermission 2	DatabasePermission	1
Account	Dimension	1
Adventure Works Account	CubeDimension	2
Customer Mining	MiningStructure	2
Subcategory Associations	MiningModel	3
Customer Clusters	MiningModel	3
Department	Dimension	1
Adventure Works Department	CubeDimension	2
Employee	Dimension	1
Adventure Works Employee	CubeDimension	2
Geography	Dimension	1
Adventure Works Geography	CubeDimension	2
Organization	Dimension	1
Adventure Works Organization	CubeDimension	2
Reseller	Dimension	1
Adventure Works Reseller	CubeDimension	2
Reseller Sales Order Details	Dimension	1
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
Sales Channel	Dimension	1
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
Sales Summary Order Details	Dimension	1
Adventure Works Sales Summary Order Details	CubeDimension	2
Scenario	Dimension	1
Adventure Works Scenario	CubeDimension	2
Forecasting	MiningStructure	1
Market Basket	MiningStructure	1
Sequence Clustering	MiningStructure	1
Targeted Mailing	MiningStructure	1
TM Neural Net	MiningModel	2
TM Naive Bayes	MiningModel	2
TM Clustering	MiningModel	2
TM Decision Tree	MiningModel	2
LimitedRole	Role	1
Mined Customers CubePermission 1	CubePermission	2
Adventure Works CubePermission 1	CubePermission	2
RoleDupe	Role	1

Code

Database.AdventureWorksDW.xmla