| Property |
Value |
| Database schema name |
|
| Database table name |
Organization |
| Friendly name |
Organization |
| Table name |
dbo_DimOrganization |
| Table type |
View |
| Is loaded |
True |
SELECT o.OrganizationKey, o.ParentOrganizationKey, o.PercentageOfOwnership, o.OrganizationName, o.CurrencyKey, c.CurrencyAlternateKey
FROM DimOrganization AS o INNER JOIN
DimCurrency AS c ON o.CurrencyKey = c.CurrencyKey |
| Relation name |
Child (foreign key) columns |
Parent name |
Parent type |
Parent (primary key) columns |
| FK_DimOrganization_DimOrganization |
ParentOrganizationKey |
Organization |
View |
OrganizationKey |
| DimOrganization-DimDestinationCurrency |
CurrencyKey |
Destination Currency |
View |
CurrencyKey |
Total: 2 parent relationship(s)
| Relation name |
Parent (primary key) columns |
Child name |
Child type |
Child (foreign key) columns |
| FK_DimOrganization_DimOrganization |
OrganizationKey |
Organization |
View |
ParentOrganizationKey |
| FK_FactFinance_DimOrganization |
OrganizationKey |
FactFinance |
Table |
OrganizationKey |
Total: 2 child relationship(s)
| Name |
Type |
Computed column expression |
| OrganizationKey |
System.Int32 |
|
| ParentOrganizationKey |
System.Int32 |
|
| PercentageOfOwnership |
System.String |
|
| OrganizationName |
System.String |
|
| CurrencyAlternateKey |
System.String |
|
| CurrencyKey |
System.Int32 |
|
Total: 6 column(s)