Database reference - Adventure Works DW

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

typecount
data sources 
data source views 
cubes 
dimensions  21  
mining structures  5  
roles  3  
assemblies  0  

Database properties

namevalue
nameAdventure Works DW
IDAdventure Works DW
created3/26/2009 10:43:57 PM  
stateProcessed  
last schema update2/11/2010 8:09:28 PM  
last processed2/11/2010 8:09:59 PM  
loadedTrue  
collationLatin1_General_CI_AS  
language1033  
data source impersonation modeDefault  

Server properties

namevalue
nameSPRING\KATMAI
product nameMicrosoft SQL Server code name "Katmai" Analysis Services
editionDeveloper
product levelSP2
version10.0.4000.0

Dependency graph

Adventure Works DWAdventure WorksMined CustomersDatabasePermissionDatabasePermission 1DatabasePermission 2Adventure Works DWClustered CustomersSubcategory Basket AnalysisAccountClustered CustomersCustomerDateDepartmentDestination CurrencyEmployeeGeographyInternet Sales Order DetailsOrganizationProductPromotionResellerReseller Sales Order DetailsSales ChannelSales ReasonSales Summary Order DetailsSales TerritoryScenarioSource CurrencySubcategory Basket AnalysisCustomer MiningForecastingMarket BasketSequence ClusteringTargeted MailingAdventure Works DWLimitedRoleRoleRoleDupe

Objects that depend on Adventure Works DW

nameobject typelevel
Mined CustomersCube1
Mined Customers Internet Sales Order DetailsCubeDimension2
Mined Customers Sales ReasonsMeasureGroup3
Mined Customers Internet CustomersMeasureGroup3
Mined Customers Internet OrdersMeasureGroup3
Mined Customers Subcategory Basket AnalysisCubeDimension2
Mined Customers Clustered CustomersCubeDimension2
Mined Customers Destination CurrencyCubeDimension2
Mined Customers Exchange RatesMeasureGroup3
Mined Customers Source CurrencyCubeDimension2
Mined Customers Sales TerritoryCubeDimension2
Mined Customers CustomerCubeDimension2
Mined Customers PromotionCubeDimension2
Mined Customers ProductCubeDimension2
Mined Customers Delivery DateCubeDimension2
Mined Customers Ship DateCubeDimension2
Mined Customers DateCubeDimension2
DatabasePermissionDatabasePermission1
DatabasePermission 1DatabasePermission1
DatabasePermission 2DatabasePermission1
AccountDimension1
Adventure Works AccountCubeDimension2
Customer MiningMiningStructure2
Subcategory AssociationsMiningModel3
Customer ClustersMiningModel3
DepartmentDimension1
Adventure Works DepartmentCubeDimension2
EmployeeDimension1
Adventure Works EmployeeCubeDimension2
GeographyDimension1
Adventure Works GeographyCubeDimension2
OrganizationDimension1
Adventure Works OrganizationCubeDimension2
ResellerDimension1
Adventure Works ResellerCubeDimension2
Reseller Sales Order DetailsDimension1
Adventure Works Reseller Sales Order DetailsCubeDimension2
Adventure Works Reseller OrdersMeasureGroup3
Reseller_Orders_2004Partition4
Reseller_Orders_2003Partition4
Reseller_Orders_2002Partition4
Reseller_Orders_2001Partition4
Sales ChannelDimension1
Adventure Works Sales ChannelCubeDimension2
Adventure Works Sales OrdersMeasureGroup3
Total_Orders_2004Partition4
Total_Orders_2003Partition4
Total_Orders_2002Partition4
Total_Orders_2001Partition4
Adventure Works Sales SummaryMeasureGroup3
Total_Sales_2004Partition4
Total_Sales_2003Partition4
Total_Sales_2002Partition4
Total_Sales_2001Partition4
Sales Summary Order DetailsDimension1
Adventure Works Sales Summary Order DetailsCubeDimension2
ScenarioDimension1
Adventure Works ScenarioCubeDimension2
ForecastingMiningStructure1
Market BasketMiningStructure1
Sequence ClusteringMiningStructure1
Targeted MailingMiningStructure1
TM Neural NetMiningModel2
TM Naive BayesMiningModel2
TM ClusteringMiningModel2
TM Decision TreeMiningModel2
LimitedRoleRole1
Mined Customers CubePermission 1CubePermission2
Adventure Works CubePermission 1CubePermission2
RoleDupeRole1

Code

Database.AdventureWorksDW.xmla



Documentation generated by SqlSpec