Reputation: 407
Is there a relation between DimensionFinancialTag and (DimensionFocusBalance or Ledger or MainAccount or DimensionAttributeValueCombinison)
I have a query in sql server and i want to join DimensionFinancialTag to DimensionFocusBalance or Ledger or MainAccount or DimensionAttributeValueCombinison)
Can anybody help in this regard
Regards
Upvotes: 0
Views: 1261
Reputation: 4438
I would try to accomplish this task over the relation from DimensionFinancialTag
to the DimensionAttributeValue
and from there to the Ledger Dimensions down to the DimensionAttributeValueCombination
.
Have a look at the following image:
Source: MSDN - Ledger account combinations - Part 1 (Dimensions)
Upvotes: 3