3376012 - Data inconsistency when running currency conversion back and forth multiple times in SAP Analytics Cloud (SAC)

Currency conversion steps the data action are executed both ways from Group Currency (GC) -> Local Currency (LC) and then LC -> GC. It leads to data loss / difference.

For example, the original data is 100000. After you run the currency conversions from GC -> LC and then LC -> GC, it becomes 99999.9999997.

• SAP Analytics Cloud (Enterprise)

1. Create a data action containing the currency conversion step to convert the data from the group currency to local currency.
2. Create a data action containing the currency conversion step to convert the same data from the local currency to group currency.
3. Run these 2 data actions.
4. The data value is different than the original value.

Due to the finite precision of measure values, performing a currency conversion can cause rounding errors if the result is not exactly representable within the precision of the measure. If multiple currency conversions are performed in sequence, these rounding errors could add up and become significant. This is also explained in KBA 3216492.

For the reason mentioned above, the behavior cannot be improved, unfortunately.

If you cannot compensate these rounding errors, you would have to adjust your process to avoid doing the the conversions in the first place.

One way to do that might be using a conversion measure in the model instead of a conversion step in a data action, which would allow to access both the original and the converted values at the same time.

•  KBA 3216492 - The default currency values are slightly different between the public version and the private version in SAP Analytics Cloud for Planning (SAC)

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, 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, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, , rounding, rounded, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-PL-DA , Data Actions , Problem