Database reference - Adventure Works DW

MeasureGroup - Adventure Works - Financial Reporting

Measure group properties

namevalue
nameFinancial Reporting 
parent cubeAdventure Works 
description 
idFact Finance 
typeFinancialReporting 
storage modeMolap 
estimated rows39409 
estimated size (mb).39 
processing modeRegular 

Measures

namedescriptioniddatatypesourceformat stringexpressionaggregate functionperspectives
Amount    Amount  Double  dbo_FactFinance.Amount  Currency    ByAccountFinance 

Dimensions

nametype
Adventure Works Destination Currencyreference 
Adventure Works Accountregular 
Adventure Works Departmentregular 
Adventure Works Organizationregular 
Adventure Works Scenarioregular 
Adventure Works Dateregular 

Calculated members

namedescriptioncalculation
[Scenario].[Scenario].[Budget Variance %]    MdxScript 
[Scenario].[Scenario].[Budget Variance]    MdxScript 
Summary P&L    MdxScript 

Partitions

namedescriptionidsourcestorage modeprocessing mode
Finance    Finance  ..  Molap  Regular 

Perspectives where visible

name
Finance 

Dependency graph

Adventure WorksAdventure Works Destination CurrencyAdventure Works Dim AccountAdventure Works Dim Department GroupAdventure Works Dim OrganizationAdventure Works Dim ScenarioAdventure Works Order Date Key - Dim TimeAdventure Works Financial ReportingFinance

Objects that Adventure Works Financial Reporting depends on

nameobject typelevel
Adventure Works Destination CurrencyCubeDimension1
Adventure Works Dim AccountCubeDimension1
Adventure Works Dim Department GroupCubeDimension1
Adventure Works Dim OrganizationCubeDimension1
Adventure Works Dim ScenarioCubeDimension1
Adventure Works Order Date Key - Dim TimeCubeDimension1

Objects that depend on Adventure Works Financial Reporting

nameobject typelevel
FinancePartition1



Documentation generated by SqlSpec