Skip to Content
Aug 09, 2020 at 07:43 AM

Data Mismatch issue in SQL Live Connection SAP Analytics Cloud


I have created a live SQL connection for my SAP Analytics Cloud Dashboard, but interestingly the sum value of a measure (say Amount) is different from the SQL query sum of that same measure( Amount). The number of line items are same in both SAC and SQL Table.

This issue was resolved by changing the Scheduled Jobs to import data to "Clean and Update" from "Update" option

I seriously don't understand, the reason why "Update" option in SAC has an Data issue as it just appends or update the rows right.

PS: The live connections updates every day