SAP Knowledge Base Article - Public

3227370 - No data is exported to BW from SAC


In SAP Analytics Cloud for Planning (SAC), you create an Odata service export job to export data from SAC to a BW aDSO.

The job is finished successfully. However, if you check in the BW aDSO, no data is exported to it.

When the issue happens, "Transformation error on deserialization " error can be found in tcode /N/IWFND/ERROR_LOG.

Also, if you enable the payload trace in tcode /N/IWFND/TRACES, you will find some red requests when reproducing the issue.
The response of the red request says:

  • "value" : "Transformation error on deserialization."
    "message" : "Value YYYY-MM is not a valid date in accord with the XML format for ABAP"


  • SAP Analytics Cloud (Enterprise) 2022


The format at the SAC side has only the format of "YYYY-MM", but the date type at the BW side requires the format "YYYY-MM-DD".
These 2 types don't match. As a result, it cannot be written into BW system.

In the sense of semantics, it doesn't make sense for a month granularity to be written to day granularity. There is no such disaggregation/distribute function at the BW side to break a month down to the day. The export function is just writing data to aDSO row by row.


Please reconsider your design. For example, change the characteristic of the time dimension to 0CALMONTH in aDSO which accepts a month granularity.

See Also

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


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, BW, empty, 0 record, writeback, write back, written, Transformation error on deserialization. , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , BW-PLA-BPC , BPC 'embedded model' , Problem


SAP Analytics Cloud all versions