SAP Knowledge Base Article - Public

2855524 - Inconsistency between SAC and S/4HANA CLOUD

Symptom

1. Data does not match between SAC and S/4HANA CLOUD

2. It only happens to certain dimension members

Environment

  • SAP Analytics Cloud 2019.15

Reproducing the Issue

  1. user loads data from S/4HANA CLOUD to Planning Model in SAC
  2. the import schedule is incremental load
  3. compare the data under same data region
  4. data in SAC is missing

Cause

Import Schedule Customizing

Resolution

Workaround:

  1. Please make a Full Load to ensure there is no missing data in SAC.

Things to consider:

  1. Check the incremental load if the data load meets the three restrictions on the column data for the column user picks:

    1. The values must be unique.
    2. The data must be incremental.
    3. Previously imported data must be unchanged.

  2. Recommend to bring in the transaction ID as the incremental load column as this column satisfies the restrictions stated above
     
  3. Not Recommend to use the transaction date time integer column as the incremental load column, 
    because there is no guarantee that these values are unique. 
    If multiple transactions happen at the same timestamp durubg the data acquisition import schedule, there is a high chance of a timing issue. 

    Alternative way if user has to use "transaction date time integer column": 
    1. User need to schedule a timeslot for the import job where there are no new transactions being entered into the DB.
      This way will reduce the chances of the timing issue occurring using incremental load.

    2. After each import job run, user will need to compare the data and ensure that it matches the data in source system.
      Incase of missing data, user could then use the replace subset option to fix the data without bringing in the full data again.

  4. See reference: Help document: 
    https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2019.8/en-US/0e48b89d83a943cb9e8d68e1ea5b13ea.html

  5. the incremental load will only bring in rows where the column value of the selected column is greater than the column value that was stored in the previous run. 
     
  6. the data rows could have been dropped is due to the rows being rejected in wrangling.
    If the rejected rows were not added back manually, then they would be missing from the SAC model.

See Also

Your feedback is important to help us improve our knowledge base.

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 , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-BR , Digital Boardroom (DiBo) , LOD-ANA-PL , Planning Functionality, Planning Models , LOD-ANA-PR , Predictive Scenarios, Smart Predict , Problem

Product

SAP Analytics Cloud 1.0