Database reference - Adventure Works DW

Partition - Finance

Partition properties

namevalue
nameFinance 
parent measure groupFinancial Reporting 
description 
idFinance 
sourcedbo_FactFinance
storage modeMolap 
processing modeRegular 

Proactive caching properties

namevalue
silence interval-PT1S 
latency-PT1S 
silence override interval-PT1S 
force rebuild interval-PT1S 
aggregation storageMolapOnly 
online mode 
source typeProactiveCachingInheritedBinding 
source notification techniqueServer 

Dependency graph

AggregationDesignAdventure Works DWAdventure Works Financial ReportingFinance

Objects that Finance depends on

nameobject typelevel
AggregationDesignAggregationDesign1
Adventure Works Internet SalesMeasureGroup2
Adventure Works Destination CurrencyCubeDimension3
Adventure Works Dim CurrencyCubeDimension3
Adventure Works Dim CustomerCubeDimension3
Adventure Works Dim ProductCubeDimension3
Adventure Works Due Date Key - Dim TimeCubeDimension3
Adventure Works Ship Date Key - Dim TimeCubeDimension3
Adventure Works Order Date Key - Dim TimeCubeDimension3
Adventure Works Sales ReasonCubeDimension3
Adventure Works Internet Sales Order DetailsCubeDimension3
Adventure Works Dim Sales TerritoryCubeDimension3
Adventure Works Dim PromotionCubeDimension3
Adventure Works DWDataSourceView1
Adventure Works Financial ReportingMeasureGroup1
Adventure Works Dim AccountCubeDimension2
Adventure Works Dim Department GroupCubeDimension2
Adventure Works Dim OrganizationCubeDimension2
Adventure Works Dim ScenarioCubeDimension2



Documentation generated by SqlSpec