Data seed and fx rate
Hi All, I want to copy Data seed from one scenario to another scenario.(example current year actual to Prior year actual Scenario with different rate. can anyone help on this
Forum Discussion
The rates are stored in the FX rates table so you're not copying the rates when you run your calculate statement - unless you're doing some custom translation using cube rates vs OneStream's native functionality. If your destination scenario yields the same results as your source scenario in both local and translated data, my guess is that your FX rates in your source Rate Type are the same as the FX rates in your destination Rate Type. You need to copy prior year's rates from the source Rate Type into the current year of the destination Rate Type.
Hi Chul,
I have given the seed formula as below and its taking all the local value and converting with same fx rate. even i have linked different rate for destination scenario. Simply i want to see the actuals numbers in different fx rate.
api. Data. Calculate (s#source) =(s#destination)
Best practice is to condition the api.data.calculate statement to run only for base entities and local currency. If you're missing the condition, it's running unnecessarily and copying your translated amounts from your source.