SAP Knowledge Base Article - Public

3034409 - currency conversion involved with account formula in SAC

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

  1. Currency conversion is executed prior to account formula
  2. account formula operates based on the currency conversion's output
  3. 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

    Product

    SAP Analytics Cloud 1.0