Database reference - Adventure Works DW

Dimension - Subcategory Basket Analysis

Dimension properties

namevalue
nameSubcategory Basket Analysis 
idSubcategory Basket Analysis 
description 
created3/26/2009 10:43:58 PM 
last schema update2/11/2010 8:09:39 PM 
loadedTrue 
last processed3/26/2009 10:49:52 PM 
stateProcessed 
type 
language1033 
collationLatin1_General_CI_AS 
unknown member nameUnknown 
attribute all member nameAll Subcategory Baskets 
data source viewSubcategory Basket Analysis 

Attributes

namedescriptiondefault memberidtypeusageestimated counthierarchiesperspectives
Attribute Name      ATTRIBUTE_NAME           
Node Unique Name      NODE_UNIQUE_NAME    Key       
Subcategory Baskets      PARENT_UNIQUE_NAME    Parent       

Proactive caching properties

namevalue
silence interval-PT1S 
latency-PT1S 
silence override interval-PT1S 
force rebuild interval-PT1S 
aggregation storage 
online mode 
source typeProactiveCachingInheritedBinding 
source notification technique 

Dependency graph

Adventure Works DWSubcategory Basket AnalysisSubcategory AssociationsSubcategory Basket AnalysisMined CustomersMined Customers Subcategory Basket Analysis

Objects that Subcategory Basket Analysis depends on

nameobject typelevel
Adventure Works DWDatabase1
Subcategory AssociationsMiningModel1
Customer MiningMiningStructure2
Sales Summary Order DetailsDimension3
Destination CurrencyDimension3
Sales ChannelDimension3
Internet Sales Order DetailsDimension3
Reseller Sales Order DetailsDimension3
Sales ReasonDimension3
Source CurrencyDimension3
DateDimension3
AccountDimension3
OrganizationDimension3
DepartmentDimension3
ScenarioDimension3
EmployeeDimension3
Sales TerritoryDimension3
GeographyDimension3
ProductDimension3
PromotionDimension3

Objects that depend on Subcategory Basket Analysis

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

Code

Dimension.SubcategoryBasketAnalysis.xmla



Documentation generated by SqlSpec