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
- SAP Analytics Cloud REST API Developer Guide -> /jobs/jobID (POST)
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