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”.
