Symptom
A planning model with currency conversion enabled does not show any currency conversion regardless of the currency chosen in a story.
An alternate symptom is that some account members show currency conversion while others do not.
Other models on the same tenant may work as expected using the same currency conversion table as the problematic model.
There are no error Messages.
All the currency rates are maintained.
Environment
- SAP Analytics Cloud (Enterprise)
Reproducing the Issue
Create a planning model with currency conversion enabled.
Assign an Account dimension where dimension members.
Cause
This issue occurs if:
- there is no rate type specified for account dimension members. For instance you may not wish to specify a rate type if all the data being imported is already normalized and you do not wish to have any sign reversal on the data
- AND the "Units & Currencies" column is blank.
In this case the code logic of SAC considers the dimension members as NFIN (non-financial) and does not apply any currency conversion.
Resolution
Add the CURRENCY value to the "Units & Currencies" column for SAC logic to consider account members as financial data and apply currency conversions.
See the following help guides for more information:
See Also
- SAP Analytics Cloud & Currency Conversion (Part 1)
- SAP Analytics Cloud & Currency Conversion (Part 2)
- SAP Analytics Cloud & Currency Conversion (Part 3)
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 2851317 - Where can you find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
- 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?
- 2511489 - Troubleshooting performance issues in 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 Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, , KBA , only local currency shows in story regar , why the currency conversion is not worki , error in currency conversion , LOD-ANA-PL , Planning , Problem