Forum Discussion
Solved
Complex Complex Expresion in Transformation Rules
Hello Everyone,
Is there a way to force the composite expression to run before the One To One Rules ?
i am trying to run a complex expression to override values coming from the Source Data....
In your case, I would suggest using composite rules instead of on-to-one mapping to differentiate mapping behaviours depending on the ud2 value. Also, composite rules have access to complex expressions and they are only slightly more complex than one-to-one.
ChristianW
OneStream Employee
OneStream EmployeeJust add the dimensional prefix, in case of an account mapping: A#1234567 becomes 60000:
I would keep the number of composites to a minimum because they are not as straightforward to administer. You only need to have 1 composite to set the UD2 to None for BS accounts - I would use the BRApi.Utilities.TransformText function in a Business Rule (set the source expression to UD2#*). Create a lookup table for the BS accounts and the Business Rule returns None if the account is BS, otherwise it returns nothing. Then put all the UD2 maps in the List type similar to the current One-to-One maps. I haven't tested it but it should work.
