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'.
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.]
- SAP Analytics Cloud 2017.9
Missing currency rate types in the currency conversion table.
Add the missing currency rates and rate types in the currency 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.
- Currency Tables
- Adding Missing Rates in a Currency Table
- Help resources
- Help portal
- SAP community network ( Questions & Answers / Direct Link to Create Question / Blogs )
- SAP community wiki
- Ideaplace forum ( for enhancement requests & new features )
- Video tutorials
- Videos by topic areas: ( Overview, What's New, Models and Connections, Stories, SAP Digital Boardroom, Planning, Predictive, Collaboration, Administration )
- Training events
- Past event recordings
- New user handbook
- How to connect to on-premise data
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
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.
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, , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem