Database overview

Documentation

Documentation generated on: 5/14/2009 10:40:42 PM

Estimated size: 49.76 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	1
database permissions	1
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	4/9/2009 7:53:10 PM
last processed	4/9/2009 7:53:28 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	RTM
version	10.0.1600.22

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 Subcategory Basket Analysis	CubeDimension	2
Mined Customers Clustered Customers	CubeDimension	2
Mined Customers Destination Currency	CubeDimension	2
Mined Customers Source Currency	CubeDimension	2
Mined Customers Sales Territory	CubeDimension	2
Mined Customers Sales Reason	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
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
Sales Channel	Dimension	1
Adventure Works Sales Channel	CubeDimension	2
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
admin role	Role	1

Code

Database.AdventureWorksDW.xmla