11-10-2022 10:50 AM - last edited on 05-03-2023 09:01 AM by JackLacava
We have an entity that has been sold and it's last data load into OneStream was in October. We need to load the same data into November and December. I can do a Data Management copy job to load that same data with no issues. This data contains local currency entities. The issue we need to solve for, is this data needs to translate at the October rates for November and December so that at the top of the entity structure the data remains the same values, and not take into effect the November and December exchange rates. Trying to figure out the best way to accomplish this. Thank you!
11-14-2022 07:46 AM - edited 11-14-2022 07:48 AM
You want to set the Rule Type* option, on the Scenario holding that data, to Periodic. That will ensure that data is translated as "Prior period’s translated value + (YTD change from prior period * translation rate)". As the YTD change is 0, the data should stay translated as in the previous months.
If that's not possible, then you'll have to write some custom formula or translation logic.
11-15-2022 07:34 PM
Is the Solution "Rule Type* option, on the Scenario holding that data, to Periodic" holds good with Balance Sheet data also.