The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
OSAdmin
OneStream Employee
OneStream EmployeeSign Flip for Account in Transformation Rule (Complex Expression)
Originally posted by Krishna Srinivasan
Hi - I have a requiremnt to flip a sign for a particular account in the transformation rule complex expression ? is there way to do it ?
Thanks
Krish...
If it is a particular account and only one account make it simply a one-to-one. No need to get crazy with complex expressions. Use the simplest method first.
Even if its in a range of accounts, such as 100-200, if you put 150 in the one-to-one it will be the dominant mapping.
If it requires other information, there are multiple ways to achieve this. Does it need information from another dimension such as source product? You can use a composite rule.
OSAdminOneStream Employee
OneStream EmployeeIf it is a particular account and only one account make it simply a one-to-one. No need to get crazy with complex expressions. Use the simplest method first.
Even if its in a range of accounts, such as 100-200, if you put 150 in the one-to-one it will be the dominant mapping.
If it requires other information, there are multiple ways to achieve this. Does it need information from another dimension such as source product? You can use a composite rule.
This solution kind of works, but can be very painful in certain situations... If you just want to flip the sign when the target account is of type revenue or liability, being able to use a complex expression or conditional rule would be way easier than defining ranges and cherry picking exceptions!
Or you can modify the query in the source system to flip the sign. With integrations, this has generally been my approach.
