SAP Knowledge Base Article - Public

3340354 - Data is missing in the SAP Analytics Cloud (SAC) model when you load data with the Data Import Service API

Symptom

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

  • You import data from an external system to SAC using the Data Import Service API (DIS).
  • When you run the endpoint /jobs/jobID/status, the "totalNumberRowsInJob" is for example, 100 and "failedNumberRows" is 0, which means all the records are loaded into SAC sucessfully.
  • However, when you check the data at the SAC side from the Modeler -> Data Foundation View, the data is missing.
  • If you check the data at the SAC side from the Modeler -> Data Foundation View -> select the “public.Actual” version, you should see the missing data.

Environment

  • SAP Analytics Cloud 2023

Cause

In the endpoint /jobs/jobID (POST), it’s possible to specify a default value for columns, which is inserted if nothing is specified in the supplied data. On top of this, the service automatically inserts a default value of “public.Actual” for Version if none is specified. 

In your case, in the endpoint /jobs/jobID (POST), you did not specify the version value in the Data property or set another version as the default value of version. So the data is imported to the “public.Actual” version.

Please see the help page of /jobs/jobID (POST) for more details.

Resolution

If you want to load the data to a different version than “public.Actual”, please specify the version value in the Data properties or set that version as the default value of the version dimension in the endpoint /jobs/jobID (POST).

See Also

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.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, some, part of the data, empty, not successful , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem

Product

SAP Analytics Cloud 1.0