We have a requirement to derive account based on Data value. (If data value is Positive Asset Account , if negative Liability account)
This has to be done for range of accounts. I am not sure if there a any functions to refer data value for row? (GetSource and GetTarget seem to be only for dimension data)
Any ideas on how we can achieve this?
Thanks In Advance,
Solved! Go to Solution.
Sorry for the delay.
I had started to work on it but unfortunately account hierarchy is little messy and we do not have a defined range. Due to missing range Derivate rules are becoming complex. We went with the Event Handler rule that runs after transformation,