Symptom
Display Currency and Display Currency - Conversion Date fields are not appearing as parameters in the selection tab for customozied report.
Reproducing the Issue
- Go to Business Analytics Work Center.
- Go to Design Reports view.
- Open the custom report created.
- 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