Forum Discussion

kustrup's avatar
kustrup
New Contributor
2 years ago

How to setup transformation rule to map if an item is a child member of a (another) dimension parent

I am looking to create a transformation rule for Accounts to map to a destination if the Department on the record is a child of a specific parent in the OS department dimension. ACCT600 DEPT101  -...
Transformation
kustrup's avatar
kustrup
New Contributor

Thank you for the responses! I was able to resolve the issue with an IF statement:

If BRApi.Finance.Members.IsDescendant(si, _
    BRApi.Finance.Dim.GetDimPk(si, "DIMENSION_NAME"), _
    BRApi.Finance.Members.GetMemberId(si, dimTypeID.UD3, "PARENT_MEMBER"), _
    BRApi.Finance.Members.GetMemberId(si, dimTypeID.UD3, DEPARTMENT_FOR_DATA_RECORD)) _
Then

 

That being said, it is definitely more efficient to use a global variable as franciscoamores said.

WernerN's avatar
WernerN
Contributor
15 days ago

Was looking for something unrelated but your 'If Statement' inadvertently put me in the right direction.  Much appreciate you sharing your code.