SAP Knowledge Base Article - Public

3304085 - Not all data is exported from SAP Analytics Cloud (SAC) to BW (or BW/4HANA)

Symptom

The following behavior occurs in SAP Analytics Cloud for Planning (SAC):

  • You create an odata service export job to export data from SAC to BW or BW/4HANA.
  • From the job log, the export job is completed successfully and no data is rejected.
    However, if you check the data in the target BW aDSO, you find that some data is not loaded.

Environment

  • SAP Analytics Cloud
  • SAP Business Warehouse (BW) or BW/4HANA

Cause

The key for ADSO should be unique when storing data.
If there are more than two records having the same aDSO key, then only one record will be written. And there is no guarantee which one it will be.

Resolution

Make sure the target aDSO key fields are set in a way that each SAC source record has a unique value for the key fields.

Keywords

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, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://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, some, part, missing , KBA , EPM-BPC-BW4 , BPC/4 , EPM-BPC-NW , NetWeaver Version , LOD-ANA-ML-DI , Data Integration , Problem

Product

SAP Analytics Cloud 1.0