Database overview

Documentation

Documentation generated on: 10/29/2008 10:34:13 PM

Estimated size: 8.63 mb

Summary

type	count
data sources	1
data source views	1
cubes	1
dimensions	9
mining structures	0
roles	4
database permissions	4
assemblies	1

Database properties

name	value
name	AmoAdventureWorks
ID	AmoAdventureWorks
created	8/26/2006 10:06:07 PM
state	Processed
last schema update	8/26/2006 10:06:07 PM
last processed	8/26/2006 10:06:31 PM
loaded	True
collation	Latin1_General_CI_AS
language	1033
data source impersonation mode	ImpersonateServiceAccount

Server properties

name	value
name	SUMMER
product name	Microsoft SQL Server 2005 Analysis Services
edition	Standard
product level	SP2
version	9.00.3068.00

Objects that depend on AmoAdventureWorks

name	object type	level
StoredProcedures	ClrAssembly	1
Adventure Works	Cube	1
Adventure Works Reseller Sales Order Details	CubeDimension	2
Adventure Works Internet Sales Order Details	CubeDimension	2
Adventure Works Sales Reason	CubeDimension	2
Adventure Works Source Currency	CubeDimension	2
Adventure Works Product	CubeDimension	2
Adventure Works Reseller 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
Adventure Works Currency Rates	MeasureGroup	2
Fact Currency Rate	Partition	3
Adventure Works Customers	MeasureGroup	2
Customers_914	Partition	3
Customers_549	Partition	3
Customers_184	Partition	3
Adventure Works Sales Reasons	MeasureGroup	2
Fact_Internet_Sales_Reason	Partition	3
Adventure Works CubePermission 2	CubePermission	2
Adventure Works CubePermission 1	CubePermission	2
DatabasePermission	DatabasePermission	1
DatabasePermission 1	DatabasePermission	1
DatabasePermission 2	DatabasePermission	1
DatabasePermission 3	DatabasePermission	1
AdventureWorksDW	DataSourceView	1
FactCurrencyRate	Table	2
FactInternetSalesReason	Table	2
FactResellerSales	Table	2
DimSalesReason	Table	2
DimCurrency	Table	2
DimReseller	Table	2
DimCustomer	Table	2
DimProduct	Table	2
DimProductSubcategory	Table	2
DimProductCategory	Table	2
DimGeography	Table	2
DimTime	Table	2
Database Administrators	Role	1
Processors	Role	1
Readers	Role	1
Writers	Role	1

Code

Database.AmoAdventureWorks.xmla