SAP Knowledge Base Article - Public

2482105 - Currency conversion failed error. Please provide missing rates for all needed types, categories and versions in the rate table in SAP Analytics Cloud

Symptom

The following errors occur when trying to view data in story or publishing a version in a story using a model with currency (conversion) translation enabled in SAP Analytics Cloud (SAC):

  • The currency conversion failed. Please provide missing rates for all needed rate types and categories in the rate table 'sap.epm:Currency_Rates'.
  • Could not convert from '<Currency1>' to '<Currency2>' on '<Date>'. Please provide missing rates for all needed types, categories and versions in the rate table.
  • Sorry, we were unable to publish data from version 'A' to 'B'

The following error may also appear

  • Unable to retrieve data from the datasource.
    Error: [Could not convert from 'AUD' to 'EUR' on '01.01.2020'. Please provide missing rates for all needed types, categories, and versions in the rate table.]

Environment

  • SAP Analytics Cloud

Cause

Missing currency rate types in the currency conversion table.

Resolution

Add the missing currency rates and rate types into the currency conversion table.

See Displaying Currencies in Tables.

If the currency table does not contain rates for all of the conversions in your story / table, a message appears noting that rates are missing. If you have the appropriate permissions to edit or view the currency table, you can select Add Missing Rates to open the currency table. The Add Missing Rates panel will show the information for the rates that need to be added for a given currency.

If the correct rates exist in the currency conversion (rate) table then see the resolution in 2632276 - The currency conversion failed. Please provide missing rates for all needed rate types and categories in the rate table {0} error in SAP Analytics Cloud (SAC).

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, Cannot currency conversion on SAC even though adding currency rates, currency conversion table ,  FX table , KBA , the result is that we are unable to publ , publish trhe changes we are doing for th , doing for the planning model. , LOD-ANA-ML , SAC Modelling , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0