Data Copy - What Happens When Different Entity Currencies are Involved?

Observations:

• OneStream will not copy a Local USD amount into a Local CAD cell. This is expected OS behavior.
• OneStream will not automatically translate prior to the Copy. The translate must be done prior to the Copy rule executing (either manually by the user or automated in a Data Management (DM) step).
• The CV does not re-render/refresh after the “Copy” or “Clear” is done (minor bug). So a manual “Refresh” is necessary in order to see the completed results.

  •  To fix this, the following two dashboard buttons need to be updated as follows - one is the "Clear" button and the other is the "Copy" button:

  • 
    

    This would hold true for the other Data Copy schedules / buttons.

• You can always add a Data Management step to first do a translations / consolidation prior to the Copy DM running.

Testing Process:

I first created a TXP_CA_102_US entity. It’s the same at TXP_CA_102 but with a USD currency. Also, this new entity has no Text 7 attributes.

Next, I updated the UD7 hierarchy:

Next, I updated the National GF definitions as follows:

Next, I updated the workflow for the new entity. I put it in with the existing CA_102 entity.

 Next, I input a few pieces of data into Schedule 5. Save the data. Did a calculate to get a “OK” calc status.

Next, open up “DM 10aAdmin”, set the POV and click on Refresh. Notice that you need to perform a “TR”. If you just run the “Copy” now, nothing will copy over.

Right click on any cell in the “TR” column, and then do a Force Translate.

Now you are ready to perform the “Copy”.

After executing the “Copy”.