SAP Knowledge Base Article - Public

3521224 - Failure in Data Export from SAP Analytics Cloud (SAC) to BW due to Null Values in a dimension

Symptom

  • An issue arises when attempting to export data from a SAP Analytics Cloud (SAC) planning model, which is created on a BW query, to a different Advanced DataStore Object (ADSO) in the BW system using legacy export via ODATA services.
  • The export process fails due to Null values in date fields.
  • The rejection records indicate the following reasons: "The value of xxx is null."

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Open the SAC planning model.
  2. Navigate to Data Management.
  3. Execute the export job to Export Data to OData Services (BW and BW/4HANA only).
  4. The export fails. The detailed rejection reason is "The value of YYY is null."

Cause

This is expected behavior. The export will reject any rows which have null values for dimensions. 

Resolution

The export jobs from the modeler is now a legacy service, We suggest looking into exporting data through the newer pull API: the Data Export Service.
You can find more information in KBA 2540886 - How to export data from models in SAP Analytics Cloud?

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, dashboard, SAP Analytics Cloud, SAC, BW, Advanced DataStore Object, ADSO, Data Export, ODATA services, Null values, Date Fields, Failure, Rejection Records, POENTRDAT, VALIDFRM, VALIDTO, Data Management, ODATA_EXPORT , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem

Product

SAP Analytics Cloud all versions