Symptom
When performing the Currency Conversion within SAP Analytics Cloud, this is failing with the error below:
Missing currency conversions in rate table "CURRENCY_TABLE". Please provide missing rate for all needed types, categories and versions in the rate table to run step X ("CURR_CONV") of data action "DA" on version "XX"
Environment
- SAP Analytics Cloud
Cause
For the Account dimension of the concerned model, there is no 'Account type' and 'Rate type' maintained for some members.
Resolution
It is needed to maintain those parameters for the requested dimension members.
Keywords
Currency Conversion, Account type, Rate type , KBA , LOD-ANA-PL , Planning , LOD-ANA-ML , SAC Modelling , Problem