Forum Discussion

ChrisFeller's avatar
ChrisFeller
New Contributor
3 years ago

Discontinued entity, loading data for rest of the year

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!

Consolidation
Metadata
  • JackLacava's avatar
    JackLacava
    Community Manager
    3 years ago

    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.

    • CASubhasish's avatar
      CASubhasish
      New Contributor II
      3 years ago

      Is the Solution "Rule Type* option, on the Scenario holding that data, to Periodic" holds good with Balance Sheet data also.