Symptom
You have created a custom key figure which uses 'Currency Conversion' but when using it in the report, you cannot see all lines being converted as expected. It does not work for all currencies in the report.
Environment
- SAP Cloud For Customer
- SAP Business ByDesign
Reproducing the Issue
- Go to Business Analytics work center.
- Go to Design Reports work center view.
- Search for the report.
- Open it.
- Select 'Display Currency' as 'USD'.
- Run it.
- You can see results for custom key figure having different currencies (e.g. BRL, EUR).
Cause
There is no currency conversion maintained for the currency selected under 'Exchange Rate for Foreign Currencies' configuration of 'Default Exchange Rate Type' type. Therefore, the report cannot convert the currency since it has no reference. The analytical framework just recognizes those currencies which are maintained under 'Default Exchange Rate Type' (i.e. 001 - Default Exchange Rate Type) for the report conversion. Those currencies which were imported from different systems and are available under 'All Exchange Rate Type' selection are not considered for the custom key figure currency conversion. You can check if the required conversion is maintained in the system following these steps:
- Go to Administration work center.
- Go to Common Tasks work center view.
- Click on 'Exchange Rate for Foreign Currencies'.
- Select 'Default Exchange Rate Type'.
- You can see those currencies which the 'Display Currency' option uses.
Resolution
You can maintain a currency conversion of 'Default Exchange Rate Type' to be considered by the 'Display Currency' following these steps:
- Go to Administration work center.
- Go to Common Tasks work center view.
- Click on 'Exchange Rate for Foreign Currencies'.
- Select 'Default Exchange Rate Type'.
- Click on 'Download Excel XML Template'.
- Edit it and maintain those values as required.
- Click on 'Import'.
- Select the Excel XML file downloaded.
- You'll have a reference for the 'Display Currency' conversion.
See Also
Keywords
custom key figure, currency conversion report, display currency report, display currency, report conversion custom, key figure properties, currency properties, asterix , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To