Database reference - Adventure Works DW

Perspective - Finance

Perspective properties

namevalue
nameFinance 
parent cubeAdventure Works 
description 
idPerspective 3 
cubeAdventure Works

Dimensions

namedescriptionvisible attributes
Destination Currency  Destination Currency, Currency Code 
Account  Account Type, Account, Accounts, Account Number 
Department  Departments 
Organization  Organizations 
Scenario  Scenario 
Date  Fiscal Year, Fiscal Quarter of Year, Month of Year, Calendar Quarter, Day of Week, Day Name, Calendar Quarter of Year, Calendar Semester, Fiscal Semester, Day of Month, Day of Year, Week of Year, Month Name, Fiscal Semester of Year, Calendar Semester of Year, Date, Fiscal Quarter, Calendar Year 

Measure groups

namedescriptionvisible measures
Financial Reporting  Amount
Exchange Rates  End Of Day Rate, Average Rate

Calculations

nametypemeasure group
[Scenario].[Scenario].[Budget Variance %]MemberFinancial Reporting
[Scenario].[Scenario].[Budget Variance]MemberFinancial Reporting
Summary P&LSetFinancial Reporting

Dependency graph

Adventure WorksFinance

Objects that Finance depends on

nameobject typelevel
Adventure WorksCube1
Adventure Works DWRelationalDataSource2
Sales Summary Order DetailsDimension2
Destination CurrencyDimension2
Sales ChannelDimension2
Internet Sales Order DetailsDimension2
Reseller Sales Order DetailsDimension2
Sales ReasonDimension2
Source CurrencyDimension2
DateDimension2
AccountDimension2
OrganizationDimension2
DepartmentDimension2
ScenarioDimension2
EmployeeDimension2
Sales TerritoryDimension2
GeographyDimension2
CustomerDimension2
ProductDimension2
PromotionDimension2



Documentation generated by SqlSpec