Symptom
currency conversion result incorrect in SAC
Environment
- SAP Analytics Cloud
Reproducing the Issue
1. Account A with formula referring to Account B
2. Account B customized with a LOOKUP formula with Date Dimension referring to a date. [For example, preivous year]
3. Currency Convertion on Account A
4. Instead of using rate in current year, the system is using the rate in the previous year from Account B
Cause
Standard Behavior
Resolution
- Currency conversion is executed prior to account formula
- account formula operates based on the currency conversion's output
- in this example, the currency conversion on account B executes first, so the rate is referring to the previous year, and then account A gets the converted result from account B.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, currency, rate, exchange, translation, , KBA , LOD-ANA-PL , Planning , Problem