| Property |
Value |
| Database schema name |
dbo |
| Database table name |
DimAccount |
| Friendly name |
Account |
| Table name |
dbo_DimAccount |
| Table type |
Table |
| Is loaded |
|
| 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)
| 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)
| 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)