Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
5 years ago
Solved

Sign 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

Krishna

Transformation
  • OSAdmin's avatar
    OSAdmin
    5 years ago

    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.   

3 Replies

  • OSAdmin's avatar
    OSAdmin
    Icon for OneStream Employee rankOneStream Employee
    5 years ago

    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.   

    • Julien's avatar
      Julien
      New Contributor III
      2 months ago

      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!

      • RobbSalzmann's avatar
        RobbSalzmann
        Valued Contributor II
        2 months ago

        Or you can modify the query in the source system to flip the sign.  With integrations, this has generally been my approach.