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)