SAP Knowledge Base Article - Public

3580085 - Currency Conversion Step not working for Average and Closing Rate Type

Symptom

Currency Conversion Step not working for Average and Closing Rate Type.

When performing the Currency Conversion, it fails with the error below:

"Missing currency conversions in rate table "CURRENCY_TABLE". to run step X ("Currency_Conversion") of

data action "DA" on version "XX", Please provide missing rates for all needed types, categories and versions in

the rate table." 

 

Environment

SAP Analytics Cloud 1.0

Reproducing the Issue

  1. Maintain Source Currency and Target Currency in Currency Conversion table with Rate Type as “Average” and “Closing” 
  2. Create Currency Conversion step in Data Action 
  3. Run the data action 
  4. Getting the below error for conversion: 

    "Missing currency conversions in rate table "CURRENCY_TABLE". to run step X ("Currency_Conversion")

    of data action "DA" on version "XX", Please provide missing rates for all needed types, categories and

    versions in the rate table."

       

Cause

 The structure priority on the model is set to Measures instead of Account.

Resolution

  1. Select the Structure Priority tab on Model Preferences within the model.
  2. Select Account if the priority has been set to Measures. 
  3. Save the model.    

Keywords

Currency conversion, Structure priority, data action, rate type, currency table  , KBA , LOD-ANA-PL-DA , Data Actions , Problem

Product

SAP Analytics Cloud 1.0