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.
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
- 2632276 - The currency conversion failed. Please provide missing rates for all needed rate types and categories in the rate table {0} error
- Currency Tables
- Adding Missing Rates in a Currency Table
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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