Table: FactFinance

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   FactFinance 
 Friendly name   Finance Facts 
 Table name   dbo_FactFinance 
 Table type   Table 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


Relation name  Child (foreign key) columns  Parent name  Parent type  Parent (primary key) columns 
FK_FactFinance_DimScenario ScenarioKey DimScenario Table ScenarioKey
FK_FactFinance_DimDepartmentGroup DepartmentGroupKey DimDepartmentGroup Table DepartmentGroupKey
FK_FactFinance_DimAccount AccountKey DimAccount Table AccountKey
FK_FactFinance_DimDate DateKey DimDate Table DateKey
FK_FactFinance_DimOrganization OrganizationKey Organization View OrganizationKey
Total: 5 parent relationship(s)

Collapse image Child relations


No relationships exist

Collapse image Columns


Name  Type  Computed column expression 
OrganizationKey System.Int32  
DepartmentGroupKey System.Int32  
ScenarioKey System.Int32  
AccountKey System.Int32  
Amount System.Double  
FinanceKey System.Int32  
DateKey System.Int32  
Date System.DateTime  
Total: 8 column(s)

Collapse image See also


About this documentation