Property |
Value |
Database schema name |
dbo |
Database table name |
FactFinance |
Friendly name |
Finance Facts |
Table name |
dbo_FactFinance |
Table type |
Table |
Is loaded |
|
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)
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)