Table: DimAccount

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   DimAccount 
 Friendly name   Account 
 Table name   dbo_DimAccount 
 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_DimAccount_DimAccount ParentAccountKey DimAccount Table AccountKey
Total: 1 parent relationship(s)

Collapse image Child relations


Relation name  Parent (primary key) columns  Child name  Child type  Child (foreign key) columns 
FK_FactFinance_DimAccount AccountKey FactFinance Table AccountKey
FK_DimAccount_DimAccount AccountKey DimAccount Table ParentAccountKey
Total: 2 child relationship(s)

Collapse image Columns


Name  Type  Computed column expression 
AccountKey System.Int32  
ParentAccountKey System.Int32  
AccountCodeAlternateKey System.Int32  
ParentAccountCodeAlternateKey System.Int32  
AccountDescription System.String  
AccountType System.String  
Operator System.String  
CustomMembers System.String  
ValueType System.String  
CustomMemberOptions System.String  
Total: 10 column(s)

Collapse image See also


About this documentation