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's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

I have a custom translation rule where it looks to certain periods of a certain rate and uses it in a scenario. This prevents having to have, input and maintain different currency rates.

Originally posted by Chul Smith 2/8/2018 FX Rates - for those of you who have customers who analyze FX in different scenarios, I have a custom translation rule where it looks to certain periods o...
FX Rates
Time
OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago
Originally posted by Chul Smith

Here’s a file with three rules:


FcFromAct – referencing Actual months rates for forecast scenarios
Remeasured – simplified remeasurement method looking at tags on accounts
CubeRate – This is an example of a user entering a rate into a form. This would be used if there isn’t a specific rate or rate type specified or if for whatever reason they want to use a historic rate rather than a USD override.

https://onestreamsoftware.sharepoint.com/sites/Services/Shared%20Documents/PIE%20%28Prod%20Info%20Exchange%29/_Translation_Metadata_20190425_130315Z.xml

  • Krishna's avatar
    Krishna
    Valued Contributor
    3 years ago

    I am trying the similar approach but Certain scenario should use previous rate with current data but how I can change the Translation Algorithm for certain scenario because it is a cube settings not a scenario.