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
JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

If the number of such departments is low, the easiest approach is to have a number of Composite mappings that map A#yourAcc:U1#yourChildDept to a specific account. 

If that's not feasible, you will have to get dirty with a Complex Expression or Parser rule. You'll probably need args.GetSource or args.GetTarget to retrieve the UD member name, and BRApi.Finance.Members.IsChild (or .IsDescendant) to check if it's a child of your parent.