3374614 - Examples of how the data is exported from SAP Analytics Cloud (SAC) to BW (or BW/4HANA) via the OData Service with the Clean and Replace scope

You would like to understand how the data is exported from SAP Analytics Cloud (SAC) to BW and BW/4HANA (Using an OData service) with the Clean and Replace scope though examples.

• SAP Analytics Cloud (Enterprise)

Example:

The data in BW before exporting.

As the start, SAC has the same data with BW.

User modifies data of E1/E2/E3, deletes data of E4, and add new data of E5

If user selects the replace scope: account and entity, then:

Firstly, data in BW is cleaned based on account and entity (A1, E1), (A1, E2), (A2, E3), (A3, E5) from cleanScope and exported data. 

Note: there is no way to delete data in BW, hence post a negative value to zero it.

Secondly, write data exported from SAC

If user selects the replace scope: ONLY account , then:

Firstly, data in BW is cleaned based on account (A1,A2 and A3) from cleanScope and exported data. 

Secondly, write data exported from SAC

*Click display in internal format will display 0

** For RecordMode value: For new data, the value is “N”. For modified data, it should be “ “. Other status may be relevant when the data is not fully activated.

• Export Data Source Reference --> BW and BW/4HANA (Using an OData service)
• 2942754-SAC Writeback to BW 750
• 2838883-SAC BW Writeback - Part 1

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, behavior, logic, example, loading, loaded, load , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , EPM-BPC-NW , NetWeaver Version , EPM-BPC-BW4 , BPC/4 , How To