2584378 - Currency Conversion Not Working for Key Figures Created as Extension Fields

SAP Knowledge Base Article - Public

2584378 - Currency Conversion Not Working for Key Figures Created as Extension Fields

Symptom

You are looking to use the 'Display Currency' selection parameter in a report, converting the currencies displayed to 'USD' for example, but for Key Figures which were created as Extension Fields, the values in the report are not converted as well as the currency does not change.

Environment

SAP CLOUD FOR CUSTOMER 1711 / 04

Cause

This is currently the system expected behavior. Since the 'Display Currency' selection parameter does not consider 'Extension Fields' or Key Figures which does not have the 'Currency Conversion' option selected (Parameter defined in step 3 of the Key Figure Creation Wizard).

Resolution

In order to display your key figure which were converted correctly, kindly follow the step by step below:

  1. Go to Business Analytics work center
  2. Go to Design Key Figures view
  3. Click on 'New' button
  4. Now, you have to proceed creating a copy of the key figure you created using the Extension Field functionality until you reach the third step of the Key Figure Creation Wizard
  5. When you reach the third step, in the conversion tab, select the option 'Currency Conversion' which is displayed on the drop-down menu
  6. Click on 'Finish' button
  7. Access your report and run it
  8. Click on 'Add Fields' button
  9. Click on 'Key Figures' tab and after that select the 'Own Key Figures' option
  10. Notice that the Key Figure you just created is displayed on the list, click on 'Display in Report' option and close the screen
  11. Go to 'Available Fields' tab in the report and search for the key figure you have just added in the report
  12. Check the option to disply in report and run the report again
  13. Notice now that the values displayed in this copy are now being converted to the desired currency which was specified using the 'Display Currency' selection parameter

Notice that this procedure must be followed for each key figure which was created using the Extension Field functionality and that you wish to display converted using the 'Display Currency' selection parameter in a report.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Hybris Cloud for Customer all versions