Adventure Works DW - DataSourceView

Datasource view properties

name	value
name	Adventure Works DW
id	Adventure Works DW
description
data source	Adventure Works DW
created	3/26/2009 10:43:57 PM
last schema update	2/11/2010 8:09:37 PM
loaded	True
schema	Adventure Works DW

Tables

name	case sensitive	friendly name	db schema name	db table name	type
dbo_DimAccount	False	DimAccount	dbo	DimAccount	Table
dbo_DimCurrency	False	DimCurrency		DimCurrency	View
dbo_DimCustomer	False	DimCustomer	dbo	DimCustomer	Table
dbo_DimDepartmentGroup	False	DimDepartmentGroup	dbo	DimDepartmentGroup	Table
dbo_DimEmployee	False	DimEmployee	dbo	DimEmployee	Table
dbo_DimGeography	False	DimGeography	dbo	DimGeography	Table
dbo_DimOrganization	False	DimOrganization		DimOrganization	View
dbo_DimProduct	False	DimProduct	dbo	DimProduct	Table
dbo_DimProductCategory	False	DimProductCategory	dbo	DimProductCategory	Table
dbo_DimProductSubcategory	False	DimProductSubcategory	dbo	DimProductSubcategory	Table
dbo_DimPromotion	False	DimPromotion	dbo	DimPromotion	Table
dbo_DimReseller	False	DimReseller	dbo	DimReseller	Table
dbo_DimSalesReason	False	DimSalesReason	dbo	DimSalesReason	Table
dbo_DimSalesTerritory	False	DimSalesTerritory	dbo	DimSalesTerritory	Table
dbo_DimScenario	False	DimScenario	dbo	DimScenario	Table
dbo_DimTime	False	DimTime	dbo	DimTime	Table
dbo_FactCurrencyRate	False	FactCurrencyRate		FactCurrencyRate	View
dbo_FactFinance	False	FactFinance	dbo	FactFinance	Table
dbo_FactInternetSales	False	FactInternetSales	dbo	FactInternetSales	Table
dbo_FactInternetSalesReason	False	FactInternetSalesReason	dbo	FactInternetSalesReason	Table
dbo_FactResellerSales	False	FactResellerSales	dbo	FactResellerSales	Table
dbo_vAssocSeqLineItems	False	vAssocSeqLineItems	dbo	vAssocSeqLineItems	View
dbo_vAssocSeqOrders	False	vAssocSeqOrders	dbo	vAssocSeqOrders	View
dbo_vTargetMail	False	vTargetMail	dbo	vTargetMail	View
dbo_vTimeSeries	False	vTimeSeries	dbo	vTimeSeries	View
DimDestinationCurrency	False	DimDestinationCurrency		DimDestinationCurrency	View
FactSalesQuota	False	FactSalesQuota		FactSalesQuota	View
FactSalesSummary	False	FactSalesSummary		FactSalesSummary	View

Dependency graph

Adventure Works DWAdventure Works DWAdventure Works DW Adventure WorksMined CustomersAccountCustomerDateDepartmentDestination CurrencyEmployeeGeographyInternet Sales Order DetailsOrganizationProductPromotionResellerReseller Sales Order DetailsSales ChannelSales ReasonSales Summary Order DetailsSales TerritoryScenarioSource CurrencyCustomer MiningForecastingMarket BasketSequence ClusteringTargeted MailingCurrency_RatesFinanceInternet_Sales_ReasonsSales_Quotasdbo_DimAccountdbo_DimCurrencydbo_DimCustomerdbo_DimDepartmentGroupdbo_DimEmployeedbo_DimGeographydbo_DimOrganizationdbo_DimProductdbo_DimProductCategorydbo_DimProductSubcategorydbo_DimPromotiondbo_DimResellerdbo_DimSalesReasondbo_DimSalesTerritorydbo_DimScenariodbo_DimTimedbo_FactCurrencyRatedbo_FactFinancedbo_FactInternetSalesdbo_FactInternetSalesReasondbo_FactResellerSalesdbo_vAssocSeqLineItemsdbo_vAssocSeqOrdersdbo_vTargetMaildbo_vTimeSeriesDimDestinationCurrencyFactSalesQuotaFactSalesSummary

Objects that Adventure Works DW depends on

name	object type	level

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
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
Currency_Rates	Partition	1
Finance	Partition	1
Internet_Sales_Reasons	Partition	1
Sales_Quotas	Partition	1
dbo_DimAccount	Table	1
dbo_DimCurrency	Table	1
dbo_DimCustomer	Table	1
dbo_DimDepartmentGroup	Table	1
dbo_DimEmployee	Table	1
dbo_DimGeography	Table	1
dbo_DimOrganization	Table	1
dbo_DimProduct	Table	1
dbo_DimProductCategory	Table	1
dbo_DimProductSubcategory	Table	1
dbo_DimPromotion	Table	1
dbo_DimReseller	Table	1
dbo_DimSalesReason	Table	1
dbo_DimSalesTerritory	Table	1
dbo_DimScenario	Table	1
dbo_DimTime	Table	1
dbo_FactCurrencyRate	Table	1
dbo_FactFinance	Table	1
dbo_FactInternetSales	Table	1
dbo_FactInternetSalesReason	Table	1
dbo_FactResellerSales	Table	1
dbo_vAssocSeqLineItems	Table	1
dbo_vAssocSeqOrders	Table	1
dbo_vTargetMail	Table	1
dbo_vTimeSeries	Table	1
DimDestinationCurrency	Table	1
FactSalesQuota	Table	1
FactSalesSummary	Table	1

Code

DataSourceView.AdventureWorksDW.xmla

DataSourceView - Adventure Works DW

Datasource view properties

Tables

Dependency graph

Objects that Adventure Works DW depends on

Objects that depend on Adventure Works DW

Code