| 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)