Symptom
Opportunities that were migrated from different tenant via data work bench do not show the correct currency in reports according to the Display Currency set in the selection screen
Environment
Cloud for Customer
Reproducing the Issue
- Goto Business Analytics Work Center
- Design Reports>Opportunity Analysis
- Open any view and selection, execute the report
- Add Opportunity field to rows
- Set the currency in display currency under selection screen
Some of the opportunites does not show expected Values key figure as display currency set
Cause
The Org Unit of the company is not flagged during migration leading to these inconsistencies.
Resolution
The option to adjust the currency is to do a dummy change of the Expected Value which leads to redetermination of the currency. For mass change, this can be done using the Data Workbench. Here are the main steps:
1. Maintain the import csv file: enter a different expected value for all relevant opportunities
2. Run Data Workbench update for the opportunity using known IDs on the Workcenter Data Workbench.
3. If the Expected Values shall be changed back, just repeat the above steps ( but with the right Expected Values in the csv file which you are importing
Keywords
Expected value, Opportunities, Display Currecny , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem