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
2 years ago

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
    2 months ago

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