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:

• 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.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case  for SAP Analytics Cloud?
• SAP Analytics Cloud > Learning > Guided Playlists
• SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
• Need More Help? Contact Support or visit the solution finder today!

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