Database reference - Adventure Works DW

MeasureGroup - Adventure Works - Exchange Rates

Measure group properties

namevalue
nameExchange Rates 
parent cubeAdventure Works 
description 
idFact Currency Rate 
typeExchangeRate 
storage modeMolap 
estimated rows 
estimated size (mb).28 
processing modeRegular 

Measures

namedescriptioniddatatypesourceformat stringexpressionaggregate functionperspectives
Average Rate    Average Rate  Double  dbo_FactCurrencyRate.AverageRate  #,#.00    AverageOfChildrenDirect Sales, Channel Sales, Sales Summary, Finance 
End of Day Rate    End Of Day Rate  Double  dbo_FactCurrencyRate.EndOfDayRate  #,#.00    LastNonEmptyDirect Sales, Channel Sales, Sales Summary, Finance 

Dimensions

nametype
Adventure Works Destination Currencyregular 
Adventure Works Dateregular 

Partitions

namedescriptionidsourcestorage modeprocessing mode
Currency_Rates    Currency_Rates  ..  Molap  Regular 

Perspectives where visible

name
Direct Sales 
Channel Sales 
Sales Summary 
Finance 

Dependency graph

Adventure WorksAdventure Works Destination CurrencyAdventure Works Order Date Key - Dim TimeAdventure Works Exchange RatesCurrency_Rates

Objects that Adventure Works Exchange Rates depends on

nameobject typelevel
Adventure Works Destination CurrencyCubeDimension1
Adventure Works Order Date Key - Dim TimeCubeDimension1

Objects that depend on Adventure Works Exchange Rates

nameobject typelevel
Currency_RatesPartition1



Documentation generated by SqlSpec