SAP Knowledge Base Article - Public

3690792 - Unable to select fixed currency values in graphical view in Datasphere

Symptom

  • In a graphical view, fixed currency values (e.g., EUR or USD) cannot be selected for Source Currency or Target Currency.
  • Fixed currency values are accessible when performing currency conversions in an analytic model.

         
         "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Datasphere

Reproducing the Issue

  1. Open the graphical view in SAP Datasphere.
  2. Insert a calculated columns element before the final view element.
  3. Add a currency conversion column.
  4. Attempt to select a fixed value for the source or target currency.

Cause

Fixed values of currency are read from TCURC* tables and views by the value of Client. If the Client value is blank, no fixed value can be found from relevant tables and views. 

Resolution

  1. Input the Client parameter before selecting the fixed currency. This parameter should normally be set to 000.
  2. The fixed values will be displayed while selecting Source Currency or Target Currency. 

See Also

https://help.sap.com/docs/SAP_DATASPHERE/c8a54ee704e94e15926551293243fd1d/6e3d8bed7ece4c27ba10e2cc523915fe.html?locale=en-US&version=cloud

Keywords

graphical view, fixed currency values, currency conversion, sap datasphere, dimensions, analytic model, client parameter, EUR, USD, calculated columns, data builder , KBA , DS-MD-VIW , Views , Problem

Product

SAP Datasphere 1.0

Attachments

currency.png