Loading in USD and Translating to Local

[WillVitale]

Hello,

We're building our Planning module and was wondering we have management fees that we get from our corporate office. They come in as USD. Is there a way that we can load in USD and translate them back in to Local Currency for the entities?

This is a one time yearly load and didn't know if it was possible or if we have to calculate it to local currency and then load it?

Thanks,

Will

[gkeushkerian · Accepted solution]

You can use Alternate Input currency OOB functionality.

Create two members in the Flow dimension:

• Input_USD: used to input data in USD
• LC_USD: used to translated from USD into Entity assigned functional currency

Apply the following configuration for the created members:

OneStream will run reverse translation from Input_USD into LC_USD when calculating Data Unit.

[WillVitale]

Thank you for the help to the solution!