Forum Discussion

LeAnnTDang's avatar
LeAnnTDang
New Contributor III
3 years ago

How to setup transformation rule to look at parent text value in entity dimension?

For Entity transformation rule, we want to build logic so that Source entity looks at its parent entity in one of our entity hierarchy in OS dimension, read and then map to the parent entity text8 as...
Parsing
MarkMatson's avatar
MarkMatson
New Contributor III
3 years ago

Hi,

I have used Complex expressions in the Data Source which should be able to do this, with something like:

 

If IWantParentText Then
Dim loadedEntity As Member = BRApi.Finance.Members.GetMember(si, dimType.entity, args.Value.toString)
Dim loadedEntityParent As list(Of Member) = BRApi.Finance.Members.GetParents(si, brapi.Finance.Dim.GetDimPk(si, "Entities"), loadedEntity.memberId, False)
' Return Text1
Return brapi.Finance.entity.Text(si, loadedEntityParent(0).memberId, 1)
Else
Return args.Value
End If

 

You can also put the complex expression in a mask Transformation rule.

DM me if you can't get it going and I'll see if I can help.