SAP Knowledge Base Article - Public

2358727 - Display Currency Conversion fields as parameters in custom report

Symptom

Display Currency and Display Currency - Conversion Date fields are not appearing as parameters in the selection tab for customozied report.

Reproducing the Issue

  1. Go to Business Analytics Work Center. 
  2. Go to Design Reports view.
  3. Open the custom report created.
  4. In Selection tab, the parameters 'Display Currency and Display Currency - Conversion Date' cannot be seen or added.

Cause

If none of the key figures in the report do not have currency conversion maintained as Conversion Type, the Display Currency fields cannot be seen as parameters in report.

Resolution

Currency conversion happens at Restricted or Calculated key figure. You need to select any of the key figure group or any custom key figure which involves currency conversion. This can be defined while creating the key figure in properties tab. Below are the steps to be performed:

i) Goto Business Analytics Work Center

ii) Design Key figures

iii) Click on New

iv) Select the data source on which you creating the custom report

v) Either create restricted or calculated key figure

vi) Click next > Go to Properties tab

vii) Under Conversion> Conversion Type > Currency Conversion

viii) Review and Click on Finish

Now, in report wizard of the report add this key figure under select key figures. You can see these fields 'Display Currency and Display Currency - Conversion Date' added in Define Variables tab by default on selecting the key figure. If you open the report, these fields will appear in the selection tab.

Keywords

Display Currency, Display Currency-Conversion Date, Parameter, Report , KBA , LOD-CRM-WKF , Workflow , How To

Product

SAP Business ByDesign all versions ; SAP Hybris Cloud for Customer add-ins 1608 ; SAP Hybris Cloud for Customer add-ins 1611 ; SAP Hybris Cloud for Customer add-ins 1705 ; SAP Hybris Cloud for Customer add-ins 1708 ; SAP Hybris Cloud for Customer add-ins 1711