creating a query with joining all the related tables like below,
while select RecId from dimAttrValueGroupCombo
where dimAttrValueGroupCombo.DimensionAttributeValueCombination == _ledgerDimension
join displayValue from dimAttrLevelValue
where dimAttrLevelValue.DimensionAttributeValueGroup == dimAttrValueGroupCombo.DimensionAttributeValueGroup
join RecId, DimensionAttribute from dimAttrValue
where dimAttrValue.RecId == dimAttrLevelValue.DimensionAttributeValue
join Name from dimAttr
where dimAttrValue.DimensionAttribute == dimAttr.RecId
No comments:
Post a Comment