SAP Knowledge Base Article - Public

2482105 - Currency conversion failed. Please provide missing rates for all needed rate types and categories in the rate table in SAP Analytics Cloud (SAC)

Symptom

When you create a story using a model with currency translation enabled, the following error occurs:

  • The currency conversion failed. Please provide missing rates for all needed rate types and categories in the rate table 'sap.epm:Currency_Rates'.

30-May-17 5-19-34 PM.png

The following error may also appear

  • Unable to retrieve data from the datasource.
    Error: [Could not convert from 'AUD' to 'EUR' on '01.01.2018'. Please provide missing rates for all needed types, categories, and versions in the rate table.]
    30-Jan-18 7-15-46 PM.png

Environment

  • SAP Analytics Cloud 2017.9

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.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

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 , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0