Table: Organization

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name    
 Database table name   Organization 
 Friendly name   Organization 
 Table name   dbo_DimOrganization 
 Table type   View 
 Is loaded   True 

Collapse image Query definition


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

Collapse image Parent relations


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)

Collapse image Child relations


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)

Collapse image Columns


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)

Collapse image See also


About this documentation