- Ask a Question
- Write a Blog Post
- Login / Sign-up
SAC Planning Data writing back to BW or Hana
Can any one please suggest can we write back data to BW or HANA as we do in BPC and IP .
Or data just sits in SAC and we need to read it only .Please provide me the ways to write back if possible and ways to consume woth other sap applications.
2920775 - Export of SAP Analytics Cloud (SAC) transaction data to SAP BW/4HANA 2.0 SP4 or SAP BW 750 Support Package 18 system using OData
- Export of SAP Analytics Cloud (SAC) transaction data from an SAC acquired / import planning model to SAP BW/4HANA 2.0 and SAP Business Warehouse (BW) using an OData service (export) connection is supported in BW/4HANA 2.0 Support Package 04 and SAP Business Warehouse 750 Support Package 18 .
- SAP Analytics Cloud (Enterprise)
- SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA 2.0 SP04 and higher.
- SAP BW/4HANA 2.0 SP04 and higher
- SAP Business Warehouse 750 Support Package 18
- For BW/4HANA 2.0, upgrade your system to BW/4HANA 2.0 Support Package 04, or implement the attached correction instructions of:
- Note 2838883 - SAC BW Writeback - Part 1
- Note 2847623 - SAC BW Writeback - Part 2
- For SAP BW 750, upgrade your system to SAP BW 750 Support Package 18, or implement the attached correction instructions of:
- Note 2942754 - SAC Writeback to BW 750
- Export via OData to BW 751, BW 752, BW 753 and BW 754 is not supported (i.e. S/4HANA embedded BW. See 2992417 ).
- Review the limitations, configuration and the usage of the BAdI (business add-in) in the notes listed above.
- See the following help page for more information: Exporting Data to OData Services .
- If you get errors implementing notes, see Note 2912581 - SAP delivered projects cannot be edited in your system .
- See Note 3026199 for Tips and Tricks of Analyzing BW and BW/4HANA Data Integration with SAC Issues
- See Note 3220729 Checkpoints: Import and Export Job for SAC model via OData Services
- To enable detailed logging, run report SAP_RSADMIN_MAINTAIN and add parameter 'RSBPC_ODATA_LOG' with value 'X'. See Note 3028450 - Enable log to SLG1 for OData export service .
- 2913078 - Support Clean and Replace (during export of SAC data to BW)
- 2540886 - How to export data from models in SAP Analytics Cloud?
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 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 incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP 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, SAC Export job to BW/4HANA ADSO gets, SAC exporting to BW/4HANA SP4 exported, SAPK-20004INDW4CORE, DW4CORE, 200, SAPK-75018INSAPBW, 7.50, SAP BW 7.5 on HANASAC export data connection intermittantly failing with http, Unexpected Behavior of SAC import and Export Jobs intermittently, 18, SAC Export Configuration, SAC EXPORT to BWP Failing to send data across, export failed. see details for rejected data., 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, Write Back to BW from SAC Models ODATA_EXPORT Write Back to BW from SAC Models ODATA EXPORT, Export data from SAC model to oData Service, , KBA , odata connection to bw issue , sac export data connection intermittantl , odata services export functionality not , sac export via odata to s4hana 1909 embe , sac export to acdocp - note 2816338 , export problems , rsbpc_odata , unable to export data from sac to acdocp , sac export configuration, sac export to , to bwp failing to send data across , sac bw export kba sap bw4 , write back to bw from sac models , wb writeback , rsbpc_odata_service , sac planning writeback kba , writeback connectivity from sac to bw , , dwc , dw4core , export functionality not working , embedded bw , bw4 backend , rsbpc_odata_export , exporting data to bw 750 using odata ser , bw_750 using odata services , cl_rsbpc_odata_export , 'rsbpc_odata_export' , from sac to acdocp , export , connect odata service , connection link bw , import job failing in sac import , o data export job from sac to bw fails w , bw fails with 500 error , odata odata , export job from sac to bw with odata fai , odata fails. , exporting planning data into sap bw adso , bw/4hana adso sac export , sap bw4hana from sac , error writing back to sap bw4hana from s , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , LOD-ANA-ML-DI , Data Integration , How To
SAP ANALYTICS CLOUD (SAC) Planning write back to SAP BW with ODATA
SAP Analytics Cloud offers you the possibility to build your own Planning Model and Application within SAC natively. At a certain point you might want to think about, how to get this data exported to an On-Premise SAP Business Warehouse. This document covers the solution to export the Data from a SAC Data Model back to BW with an OData connection.
OData Writeback to SAP BW
SAP is offering an out of the box solution to write Data back from SAC with an OData service. To implement this solution SAP provides a note for a SAP BW 7.5 system ( https://launchpad.support.sap.com/#/notes/2942754) and one for a SAP BW/4HANA ( https://launchpad.support.sap.com/#/notes/2838883 ). If your SAP BW 7.5 is already on SP 18 or in case of an SAP BW/4HANA 2.0 on SP4 the manual activities do not need to be performed.
In our scenario we implemented the scenario in SAP BW 7.5 SP 16.
We followed the manual steps which are in SAP Note 2942754 as our system is not on Support Package 18. There are a lot of steps, but it is a straightforward process. After finishing all the steps, you should have in transaction SEGW a model which looks like this:
And in transaction /IWFND/MAINT_SERVICE the following service:
Make also sure that in the SICF the service is up and running.
In the service leave the Logon Data empty, you will later need to define a user in the SAC connection.
The export jobs from SAC are processed in SAP BW 7.5 via bgRFC units. For a better understanding SAP is providing a documentation ( https://help.sap.com/doc/saphelp_nw73/7.3.16/en-US/48/927c2caa6b17cee10000000a421937/frameset.htm ) and SAP Note 2309399 ( https://launchpad.support.sap.com/#/notes/2309399 ) is giving more insights on how to configure them effectively.
However, as described in SAP Note 2942754 you need to configure and inbound bgRFC destination and a Supervisor Destination. The inbound queue Destination should be named “RSBPC_ODATA_EXPORT” and the Prefix “RSBPC_ODATA_EXPORT_”.
Also define a new Supervisor Destination:
It is also necessary to register the ADSO in the maintenance view “RSBPC_ODATA_V_EX” in transaction SM30. Please check the limitations regarding the ADSO mentioned in the note.
For a detailed explanation how to configure the Cloud connector please refer to the following link https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/8d8511532794429caa243b6fb7c79989.html . In the tab Cloud To On-Premise we configured the following connection. Make sure to configure a HTTPS connection.
The last step before the export is to create the connection in the SAC. Make sure to tick on the two checkboxes “Connect to an SAP OData service” and “Connect to an On-Premise OData service”.
Got to your model and click on “Data Management” and Export the Data to OData Service.
Select your connection
Then you can select the ADSOs which were defined in the maintenance view “RSBPC_ODATA_V_EX”.
Select the fields you would like to map.
You can also Filter the data you want to export with the “Add Filter” Button
Make sure the dimensions are all mapped correctly and start the export job by pressing on finish.
Finally, the data is exported to SAP BW:
As you can see in the screenshots above, we exported about ~ 450.000 records. We also exported the model from SAC 1:1 to SAP BW and it took 32 minutes. In the screenshot below we have extracted the same data but only 2 dimensions and the keyfigure (including currency), the data gets aggregated already during the export and this also has an impact on the runtime.
We got already aggregated 1605 rows and it only took 36 seconds.
If you are currently not on the required SP, which means you must implement the manual steps mentioned in the SAP Note, it might look overwhelming as already mentioned. It is just important to follow the steps precisely. Despite the long runtime the export never failed, and the data was extracted. Overall, this export via OData provides a good possibility to push data from SAC to your SAP BW system, which increases the possibilities how to use the capabilities of SAC in combination with a SAP BW system.
https://launchpad.support.sap.com/#/notes/2942754 à SAC Writeback to BW 750
https://launchpad.support.sap.com/#/notes/2838883 à SAC BW Writeback – Part 1 (SAP BW/4HANA)
https://launchpad.support.sap.com/#/notes/2628688 à OData service connection in SAP Analytics Cloud ***Master KBA***
https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/8d8511532794429caa243b6fb7c79989.html à Configuring the SAPCP Cloud Connector
https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/6dc4ed164d174c3c862f88530af7e4fd.html à Exporting Data to OData Services
https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/df2c80a3c35d4213b12053bc0885443e.html à Exporting Data Connection to OData Services
https://help.sap.com/doc/saphelp_nw73/7.3.16/en-US/48/927c2caa6b17cee10000000a421937/frameset.htm à bgRFC (Background Remote Function Call)
https://launchpad.support.sap.com/#/notes/2309399 à How to use SBGRFCCONF effectively?
Posted on August 14, 2020 in BWBLOG
- ODATA ,
- PLANNING ,
- SAC ,
- SAPANALYTICSCLOUD ,
- sapbw ,
Share the Story
Comments are closed.
- DATA FLOWS IN DWC – Part1: Introduction
- How Business Warehouse can help you in IBP Projects
- Data Modeling with CDS Views – Part 3: Session Information, Case, Cast, Where, Input Parameter & Consumption filter
- Data Modeling with CDS Views – Part 2: Currency/Unit Conversion & Date Functions
- Data Modeling with CDS Views – Part 1: Basics
- Februar 2023
- Januar 2023
- Dezember 2022
- November 2022
- Oktober 2022
- September 2022
- August 2022
- Januar 2022
- Dezember 2021
- November 2021
- Oktober 2021
- September 2021
- August 2021
- Februar 2021
- Januar 2021
- Dezember 2020
- November 2020
- Oktober 2020
- September 2020
- August 2020
- Februar 2020
- Dezember 2019
- Februar 2019
- Dezember 2018
- November 2018
- Oktober 2018
- September 2018
- August 2018
- Februar 2018
- Januar 2018
- November 2017
- Oktober 2017
- September 2017
- August 2017
- Februar 2017
- Januar 2017
- November 2016
- September 2016
- August 2016
- Februar 2016
- Dezember 2015
- November 2015
- Oktober 2015
- September 2015
- August 2015
- Februar 2015
- Januar 2015
- Oktober 2014
- Februar 2014
- Oktober 2013
- S/4 Embedded
- Feed der Einträge
Writeback from SAC to BW
SAP has made it possible to do a writeback from SAC to BW in an easy way! Watch the video below to see how.
Back in February we made an enhancement requests to SAP , which was about improving the export options from SAC to on prem BW, so you didn’t have to use flat files.
What you had to do back then was you export your data from SAC to Excel. After that you had to take your Excel document or workbook, log in to the data warehouse system and then upload your excel sheet.
The issue was that it was an extremely inconvenient way of doing it, because you had to upload all the data manually. With large quantities of data, that could very easily take a long time. Based on this we made the improvement request to SAP.
Our request was about being able to do in a more automatic way using a different integration. Fortunately, SAP listened and thought it was a good idea. They then made a change to the product, what was funny was that it wasn’t a change to SAC which we expected but a change to BW. This would allow the data warehouse to be ready to receive data in a new and smarter way.
- Future Value Chain
- Data & Analytics
- New Now in Organizations
- Supply Chain Management
- Digital Core
- Digital Supply Chain
Most Important Topics
- Life Sciences
- Integrated Business Planning
CAMELOT Consulting Group
SAP Analytics Cloud to Replace BPC?
written by Adalbert Moczygeba & Daniel von Stülpnagel
Any company that has faced the tasks of aligning enterprise processes with business strategy to pursue sufficient enterprise planning with SAP Business Planning and Consolidation (BPC) knows the hurdles and challenges that this endeavor presents. With SAP Analytics Cloud, SAP has released a solution that covers all three aspects of data visualization, planning, and predictive analytics. But is SAC suitable to replace established BPC Frontend application EPM (Enterprise Performance Management)?
Challenges during Planning…
If business planning is carried out with a solution whose functionality does not match the corporate structure and planning strategy, this would ultimately lead to a high decrease in planning effectiveness. Instead of accomplishing and incentivizing a high level of planning accuracy, we often see that clients then often deal with multiple problems: stagnating processes due to process or data inconsistencies (formatting, layouts, non-standardized or differently weighted KPIs), inclusion of different kinds of planning relevant data sources, and a very heterogeneous system landscape that is created as a result of different sub-plans being implemented in many different systems.
For some time now, SAP optimized its approach towards enterprise planning along with their other offerings. Different solutions with outstanding planning features evolved and have been used by many companies successfully for years to solve these problems. Most famous is certainly “Business Planning and Consolidation” (BPC) in its different versions. For some time now, a cloud-based frontend solution has been added to SAPs planning tool stack promising to provide additional sufficient planning capabilities.
With SAP Analytics Cloud, SAP has released its most versatile frontend that covers all kinds of features for data visualization, planning, and predictive analytics.
Yet Another Planning Tool?
With already existing and proven planning frontend tools in the market, the frequent and major question for clients is to why extend the product portfolio with yet another frontend (planning) tool? This is fair and legitimate – especially regarding the afore mentioned planning complexity, and also considering that BPC is already a powerful, deeply integrated tool with corresponding IT requirements and – to say the least – reasonable licensing costs.
One of SAPs main value proposition comes from its strategic direction focusing on cloud solutions, provided in products, such as Data Warehouse Cloud (DWC) or the frontend tool Analytics Cloud (SAC). These products are promised to deliver top-notch innovative features, an easier integration process and ease-of-usability. As they can be used via web browser, they provide high flexibility but are still highly secure. In fact, being reachable and being able to work securely with cloud solutions from any device is seen as a major benefit as compared to old and often inflexible planning frontends. BPC has a great reputation within the market of planning solutions, as it provides a broad spectrum of functionalities, covering every step of the planning process and as for the backend is still the ideal solution. Not so much its previous frontend including the add-on EPM.
For many it was unfortunate to hear SAPs announcement for an end of support for BPC (latest) by end of 2027 (or even earlier as for SAP BPC, version for Microsoft 10.1 by end of 2024), [cf. (SAP, SAP Analytics Cloud Integrated Planning, 2021) SAP Learning Platform]. This means, that not only a top-notch planning product is being sidetracked, but companies also face a deadline for exchanging their planning frontend. In this blog post, I distinct the SAP Analytics Cloud (SAC) to the previous conventional frontend of the SAP planning product BPC. For a distinction based on the provided features, please feel free to look at this blog article (Vanhouette, 2020).
A Look at the BPC Roadmap …
In the following section I will provide a rough glimpse on each distinct frontend product of BPC in both BPC standard and BPC embedded for BW/4HANA and S/4HANA. Please feel free to skip to the next section if your are familiar with the roadmap of the different BPC systems.
Firstly, I want do distinct BPCs frontend application from its backend applications, as the two best known backend applications will still play an important role in planning scenarios. These are namely BPC Standard and BPC Embedded, and they are very distinctive from each other. For both, the highly Microsoft Office-integrated EPM Plug-in provided the frontend, but it lacked ease-of-use and flexibility.
With the rollout of BW/4HANA and S/4HANA, additional BPC backend versions optimized for BW/4HANA and S/4HANA were provided, which still used EPM but at least provided the ability to use the SAC as its Frontend. The reason is the following: In S/4HANA and the SAP Business Suite scenarios, an embedded BW was used in the planning models of Integrated Business Planning (IBP) and Business Planning & Consolidation (BPC). The version of BW used in the embedded scenario was SAP BW 7.5 powered by SAP HANA, but SAP has no plans to enable SAP BW/4HANA for embedded BW. (Due to good reasons, such as sizing.)
Besides, the promise of the more integrated SAC planning solution, and SAP’s announcement to no longer support BPC with service and updates should be a good enough a call-to-action for a switch to SAC as the frontend. But it is also reasonable that companies worry about the replacement of BPCs Office Add-on. As an enthusiastic user of the SAC planning professional license, I want to present my thoughts on why the implementation of SACs planning solution would in fact be very reasonable in addition to a BW/4HANA, eventually S/4HANA. I already highlighted, that with SAC, SAP offers its customers a comprehensive and flexible, cloud-based front-end solution that not only (and opposed to EPM) provides self-service business intelligence with a promised steep learning curve, but also covers a wide range of innovative planning functionalities in areas, such as predictive analytics.
But what about feature limitations in the SAP Analytics Cloud?
Sceptic readers might judge my afore provided claim and malign the SAC for its alleged feature limitations and lack of flexibility in its customizing options in direct comparison to BPCs EPM. However, this alleged inflexibility in customization should first of all motivate planners to question the complexity within their planning processes and to put efforts in optimizing and simplifying them, thus breaking up seemingly historically risen inaccuracies. With a proper planning process in place, users can indeed make use of SACs wide range of planning features, such as easy conducted what-if analysis using a value driver tree (VDT), which depicts the value flows through the model and their hierarchical links and supports the manual adjustment of its drivers. Thus, the VDT allows for a very detailed visualization of the different links and impacts affecting on top level metrics.
Another great asset provides the wide range of features for gaining data insights and simulations on-the-fly. These encompass Smart Discovery, which uses AI to automatically highlight patterns and relationships, Smart Insights providing the key insights, Time Series Forecasting for AI-driven automatic forecasting of planning metrics, Smart Grouping for finding interrelations and deriving automatic clusters or Smart Predict where AI driven predictions are led by a manually created predictive scenario.
To sum up, the SAP Analytics Cloud has in fact grown reasonably into a top-notch, innovative enterprise frontend and planning solution. It not only provides planners easy-to-use smart analytical functions and visualization capabilities but is (in my opinion) currently also the most consolidated solution referred to its orchestration capabilities. It offers features for crowdsourcing plans and budgets across the organizations to increase engagement and accuracy and linking operational and financial planning to improve alignment and performance.
Benefits from SACs seamless integration (including roadmaps)…
The SAC can be easily integrated in the applicational environment and used as the single platform [cf. (SAP, SAP Analytics Cloud Integrated Planning, 2021) SAP Learning Platform] for fast collaborative analysis, planning and visualizations.
To support downstream data operations, the SAC enables the export of plan data from the SAP Analytics Cloud solution to SAP BW/4HANA 2.0 (SP 04) [ with login cf. ( SAP, Enterprise Planning Road Map for SAP Analytics Cloud, 2021 )] and S/4HANA. As we know SAP HANA provides the Automated Predictive Library, this library corresponds to SAP Predictive Analytics as well as the SAP Analytics Cloud Smart Predict engine. This allows developers to deploy predictive models directly in the HANA environment in different programming languages, such as R, Python or SQL.
Furthermore, it is possible to export data to other digital core and line of business solutions beyond financial information including units and volumes that are also planned in SAP Analytics Cloud. Besides, SAP enables bi-directional transfer of (forecast) data between SAC and DWC by the end of 2021. This way integration complexity is reduced as planning-relevant input data (such as actuals) can be intuitively staged and acquired through the DWC as a single source. Thus, companies will highly benefit from DWC’s development into a powerful cloud-based connection platform, supporting transformation capabilities and a multitude of diverse and easily integrated data providers, that can be seamlessly used within SACs self-service planning environment.
Also, the processing in Excel is possible using the Microsoft Analysis for office add-on of version 2.8 SP09. This version lets users connect directly to the SAC and next to all known excel features, allows the retrieval, and display of data created on a new model type for analytics and planning scenarios. The hybrid connection is solved perfectly here, and the cloud back-end can thus seamlessly work with the on-premise thick client, to consume acquired data models. The web-based table interface of SAP Analytics Cloud allows drilling and filtering Microsoft Office worksheet, but without any local client installation. With the SAP Analytics Hub, any other portal accessible via URL can be connected. For further processing in third-tier solutions, SAP plans the implementation of open APIs by 2022 to pull planning and forecasting data from SAP Analytics Cloud to external solutions. [ with login cf.( SAP, Future Releases Roadmap 2021, 2022, 2021 )].
Replacing the common Netweaver frontend…
A great prospect for companies with a long and successful BPC for Microsoft Excel frontend history, provides SAC’s mutual connection between existing SAP BPC backend environments (both based on Microsoft and NetWeaver), combining to a hybrid planning scenario of both planning solutions via import and/or write-back (BPC Standard) or even live connection (BPC Embedded) backend. Eliminating the efforts for extending BPCs Web UI, the SAC offers connections to write data back to an BPC embedded configuration model from SAC. With only the planning license needed (minimum SAP Analytics Cloud for planning, standard edition, manual coding e.g. for developing a web application and adding custom views via Java Script and .json files is thus largely being avoided. As soon as BPC data is imported into the SAC, it can be combined with other models in the SAC as the dataset for a custom frontend perspective. The table shows the main possibilities of joining BPC by connection:
Table 1: Hybrid Planning BPC Scenario [cf. (SAP, SAP Analytics Cloud Integrated Planning, 2021)] SAP Learning Platform
Currently, SAP is pushing ahead with the development of innovative features for their cloud solutions (such as the DWC). Companies that want to keep up in BI and planning are recommended to implement the SAC as their frontend, which also appears to be comparatively more cost-effective. As one of SAP’s most innovative solutions, the SAP Analytics Cloud offers a comprehensive support for features in the planning process and is easily embedded into existing architectures (including BPCs backend solution) thanks to its wide range of connection adapters. Besides being a self-service BI solution, it sets out to become a self-service planning solution, continuously simplifying its UX and successively limiting training efforts for business users or planning experts whilst supporting the creation of flexible, source-independent and consolidated planning scenarios. For this, the SAC provides planners a multitude of e. g. AI- and machine learning driven smart features, to conduct the planning in scenarios, which where, if even possible, complex to implement using older planning products.
- Dieckmann, G. (2014). Concepts compared: BPC standard and BPC embedded. blogs.sap.com.
- Kraemer, M. (2020). SAP BPC product suite extending maintenance. blogs.sap.com.
- SAP. (2017). Planning Concepts .
- SAP. (2020). Conversion Guide for Business Planning and Consolidation 11.0, version for SAP BW/4HANA. Retrieved from www.help.sap.com: https://help.sap.com/doc/7932c7378be5402eb867a6263c505108/11.1.6/en-US/loio2779d63f76fa46a1adf8e8d5fde4e24d_en.pdf
- SAP. (2020). Planning Concepts. Retrieved from help.sap.com: https://help.sap.com/viewer/69ec98e0c0e54128a61c32f3255fa438/11.1.6/en-US/4cbb4ebeed80606be10000000a42189e.html?q=planning%20concept
- SAP. (2021). Enterprise Planning Road Map for SAP Analytics Cloud. Retrieved from roadmaps.sap.com: https://roadmaps.sap.com/board?range=2020Q1-2020Q1&q=sap%20analytics%20cloud%20planning&PRODUCT=67838200100800006884#Q1%202020
- SAP. (2021). Future Releases Roadmap 2021, 2022. Retrieved from roadmaps.sap.com: https://roadmaps.sap.com/board?range=CURRENT-LAST&q=sap%20analytics%20cloud%20planning&PRODUCT=67838200100800006884#Q1%202022
- SAP. (2021). SAP Analytics Cloud Integrated Planning. In SAP, SACP30 Participant Handbook (p. 4). Walldorf: SAP. Retrieved from https://saplearninghub.plateau.com/icontent_e/CUSTOM_eu/sap/self-managed/ebook/SACP30_EN_Col27/index.html#
- SAP. (2021). SAP Business Planning & Consolidation for SAP S/4HANA. Retrieved from help.sap.com: https://help.sap.com/viewer/74785309615c47a1b7497b1f8942ebd1/2021.000/en-US/c95ad35225d10026e10000000a4450e5.html
- SAP. (n.d.). Features by License Type for Planning Models. Retrieved from www.help.sap.com: https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/20d92cebb9f94699949f99bd54a169bd.html
- Vanhouette, W. (2020). Financial planning : SAP Analytics Cloud to replace SAP Business Planning & Consolidation? blogs.sap.com. Retrieved from https://blogs.sap.com/2020/04/29/financial-planning-sap-analytics-cloud-to-replace-sap-business-planning-consolidation/
SAP S/4 Transformation: Survey on Expectations
The study "Expectations on S/4HANA in 2022" by techconsult and CamelotITLab shows possible painpoints in any migration and how they can be avoided. With data from 200 companies in Germany.
Head of Business Analytics at Camelot ITLab supporting customers from different industries in all questions around the topic of Data Driven Enterprise
Daniel von Stülpnagel
SAP BI consultant
Need help with Innovation?
Recommended articles, integrated business planning – enterprise planning for a volatile & complex world iii.
The third part of the article series on IBP for Finance leaders outlines how IBP enables finance business partners to provide …
The Role of SAP MDG in Uncertain Times
We have conducted a survey with experts in the field of Master Data Management to analyze the current maturity & market …
Success Factors for DDMRP in a Constrained Manufacturing Environment (III)
This article explains how to consider manufacturing constraints in a DDMRP environment to achieve variability and inventory reduction improvements. Part 3: Two …
Reimagine your Value Chain with us
- About TruQua
- Consulting & Implementation
- Technical Expertise
- Software Accelerators
- Continuum Services
- Publications, Presentations & Demos
- Insights Blog
- Customer Success
Mapping Planned Data from SAP Analytics Cloud to SAP S/4HANA: A Short Tutorial
Authored by Andrew Xue, Consultant, TruQua
SAP Analytics Cloud (SAC) combines the flexibility of the cloud with the ability to run new deep-level analytics allowing greater insights into critical business processes. A powerful and agile tool for planning, analytics, and predictive insights, SAP Analytics Cloud enables full-fledged collaboration from anywhere in the world and provides real-time connectivity to on-premise systems such as SAP S/4HANA to removing traditional barriers and accelerating critical business processes.
This blog will walk through a Revenue and Cost Planning example and illustrate how to export and map that planning data from SAC into S/4HANA.
Planning in SAP Analytics Cloud: A Revenue and Cost Planning Example
With the release of SAP Analytics Cloud, enterprise planning has never been easier or more efficient. With a wide array of planning capabilities and features coupled with the ability to separate hypothetical business scenarios from real data, companies are able to drive better business outcomes with collaborative enterprise planning while also gaining full alignment across all areas of the business.
In this example, you’ll see there are two planning-enabled tables located within a story in SAP Analytics Cloud. The charts on the right focus on gross margin by product and total revenue by product, which will update automatically as entries in the tables are adjusted. These entries can be made at a summarized node level by cost center groups, material hierarchies, or planned at the base level, by SKU or customer.
Source: TruQua Internal Systems
When changing the data, a draft version is created for the end-user to run their what-if planning scenarios on. This means that data changes made by the user will not be implemented until the user confirms and publishes the data. When publishing, users are provided the option to either confirm all their changes made into the model or revert to the original data. SAP Analytics Cloud is also able to highlight any data changes made to keep track of any modifications.
Exporting and Mapping Planned Data from SAP Analytics Cloud into SAP S/4HANA
Now that our we’ve run our what-if scenarios and published the data, we want to export that data into SAP S/4HANA. Thanks to the tight integration between SAC and SAP S/4HANA, we can write the new plan data directly to the S/4HANA planning table (ACDOCP).
Utilizing the easy-to-use mapping services from the SAP Analytics Cloud model, we can select what fields to map SAP Analytics Cloud dimensions to then assign those dimensions to S/4HANA fields. This is a one-time process to define or update the mappings and can be scheduled per implementation requirements.
Another point worth noting, is that within the SAP Analytics Cloud Dimension to S/4HANA field mapping process, users have the ability to create filters on their planned data as well. Meaning they be selective in the data that they upload, such as only uploading a certain period / year, or only a single cost center node. In the Versions and Categories, users may map one Analytics Cloud version to multiple S/4HANA Categories. In this example we see PLN version mapped on SAP Analytics Cloud to PLN, PLN01, and PLN02 in SAP S/4HANA.
Once the data has been successfully exported to S/4HANA, a quick ACDOCP query verifies our results.
SAP provides a wide variety of out-of-the-box sample content to inspire users on the endless creative possibilities found in SAP Analytics Cloud. With SAC’s connection possibilities (such as S/4HANA, BPC, BW, and more), systems integration previously limited to heavy IT involvement is within reach. For organizations looking to detach from a decentralized planning process, and reach collaborative enterprise planning, SAP Analytics Cloud is a perfect fit.
[This post is based on SAP Analytics Cloud version 2019.5.1 and S/4HANA 1809 SP01.]
Stay tuned for our next blog where we show you how this data can be consumed in Group Reporting and used for consolidation purposes. For more information on SAP Analytics Cloud, S/4HANA, Group Reporting, and how they can take your business intelligence to the next level, please fill out the form below.
Take your career farther. Let's create tomorrow's innovations, together.
Find out how truqua can take you farther, faster, together..
- RESOURCE CENTER / Articles
SAP Analytics Cloud Planning
SAP Analytics Cloud aims to realize projects in a shorter time period, with the ready content it offers to its solution partners. In particular, innovations in the field of planning are offered in a single package to solve the needs of our solution partners, allowing companies to make improvements specific to companies easily. Integrated Financial Planning for S4/HANA is just one of the many freeware ready-made content available to us. Thus, SAC Planning provides many ready to use content for free.
When we take a look at the model structure, we see the dimension structure as below. Dimensions and sample master data come with ready-made content. You can easily add a different size structure based on your need, to the relevant model and make your plan depending on the size you add. Also, you can easily upload your ERP system master data to the SAP Analytics Cloud and update them at regular intervals. On the right, you can check whether the uploads were successful or how many master data were updated.
In the field of data management, direct connection methods with S4/HANA system come with ready-made content. You can easily upload data from many data sources other than SAP to the SAP Analytics Cloud and send the data back to the S/4HANA system.
Integration with S/4HANA
The new tables became available in the S/4HANA.
- ACDOCA – For actuals
- ACDOCP – For Planning
With SAC Planning, we can easily read data from ACDOCA, as well as easily send the planned data to ACDOCP. We do not need to use an extra standard solution to do these operations.
In addition you can import your excel files as csv format.
If you wish, you can take over this data at any time intervals and control this process through SAP Analytics Cloud.
Value Driver Tree
With the value driver tree feature, we can make higher level planning and instantly view the changes in the sub-components that this planning depends on. We can increase and decrease the data as a percentage with the button.
With the Value Driver Tree function, we can create dummy components and view the effect of the dummy component we have created for the plans we have made at a higher level on the same screen. Thus, we can easily make more complex planning.
SAP Analytics Cloud data in Microsoft Excel
We can also access SAP Analytics Cloud via Excel. For this you can use the official add-in for Sap Analytics Cloud or SAP Analysis for Microsoft Excel both.
We can not only reach but also send data to SAP Analytic Cloud system instantly by making data entries via excel.
Easily Allocate the data
In order to be able to use and manage the distribution methods, we can perform very fast distribution operations on the system by entering the information of what to distribute where and what to use, without the need for any extra development.
If we wish, we can create them as a chain and run multiple distributions in a single chain.
Data Validations and Authorizations
It’s possible to create valid combinations between dimensions in the model using rules (even with more than 2 dimensions at a time). We can restrict the screens on which users can enter data. We can manage these validations through attributes and avoid user errors.
Using BPC for Hybrid Planning
In SAC Planning, you can do high-level planning and simulate your forecasts and also have the capability to push down the disaggregation if you are using SAP’s Business Planning and Consolidation.
In this case, SAC allows for two options:
- Import data from SAP BPC (Netweaver and Microsoft) into SAC and report on the same by mapping the dimensions, and then use SAC for planning instead of BPC and write back data to BPC from SAC
- Run predictive analysis on BPC data locally within SAC to identify trends and simulations and write back if necessary.
- The other advantage is that once the BPC data is imported into SAC, you can combine it with other data models to develop your plan further.
You can export the data from SAC Planning to different SAP BPC versions. Then, you can continue to planning with BPC functionalities.
Also, if you have an embedded model, you can use planning sequences or data trigger methods in this embedded model via SAC planning. If you have HANA BW system, you can transfer these calculated data back to SAC Planning with live connection again.
What are the main advantages of the SAP SAC Planning?
One of the main advantages of SAC Planning is ready for use with cloud technology. Nonetheless, maintenance and IT costs much less than on premise solutions.
Unified experience for Planning, BI and Predictive all in one service Live data connectivity enables SaaS for everyone end-to-end analytics the collaborative enterprise. That’s eliminates artificial barriers between Planning and Analysis. Integrated BI, Planning, and Predictive capabilities support an agile and seamless Planning & Analysis experience.
Deliver plan integration and consolidate all planning on a single platform by leveraging best-in-class connectivity to SAP solutions, and pre-delivered Best Practice content (like Cost Center Planning Business Content) to realize accelerated time to value.
WHY should use of SAP SAC Planning?
Looking at current functionalities and the roadmap of SAP Analytics Cloud, the product is ready to meet your business requirements and provide more in terms of business analytics to your end users. The on-premise product portfolio will remain in place, and SAC can be tightly integrated with your system in order to deliver a top-notch front-end and enhanced functionality.
Supporting your business processes with emerging technologies is the main goal of our business.
You’ll receive an email with download link shortly.
If not, reach us on [email protected]
You’ll receive an email shortly.
- SAP Implementation Services
- SAP Integration Services
- SAP Consulting
- SAP Rollout
- SAP Application Management Services
- SAP Offshore Development Services
- SAP BUSINESS ONE
- SAP SuccessFactors HCM
- Sales Automation
- Marketing Automation
- Helpdesk Automation
- Analytics & Intelligence
- Integration Services
- D2C Consulting Services
- Woo Commerce
- Branding & Digital Strategy
- Social Media Management
- Paid Marketing / PPC Services
- Creative Media Services
- SEO Services
- IT Staffing
- Life Sciences
- Wholesale Distribution
- Professional Services
- E-Commerce / D2C
- Start-Up & SMB
- Featured Work
- White Papers
SAP BPC Move to SAC: Work with BPC planning sequences in SAP Analytics Cloud
- March 1, 2023
The aim of this blog series is to explain the status of SAP Business Planning & Consolidation (SAP BPC) integration with SAP Analytics Cloud (SAC) and our strategic direction. Furthermore, we want to show you how SAP Analytics Cloud can extend and provide a positive ROI for your current planning, forecasting and analysis scenarios and help you run an Intelligent Enterprise. This is going to create new opportunities for planning, forecasting and analysis and thus it will help you steer your organisation even more effectively.
We also want to provide some guidance about the supported scenarios and high-level architectures and what can be done when it comes to modernising the existing planning & analysis solution of SAP BPC by adding SAC as:
a unified user experience for:
a planning (data entry) user interface, a data analysis interface,
a planning extension, a pure SAC scenario (complete move from SAP BPC).
There will be several blog posts in the series that will cover relevant topics about integration and supported workflows, so please stay tuned for the updates of this blog post with all relevant links to additional blogs of the series:
SAP BPC Move to SAC: Benefits & scenarios of moving SAP BPC planning scenarios to SAP Analytics Cloud SAP BPC Move to SAC: Use SAP Analytics Cloud as data entry UI for SAP BPC SAP BPC Move to SAC: Work with BPC planning sequences in SAP Analytics Cloud (THIS BLOG POST) SAP BPC Move to SAC: How to create a business workflow for BPC/BW live models with SAC Calendar SAP BPC Move to SAC: How to analyse data SAP BPC Move to SAC: MS Office/Excel add-in SAP BPC Move to SAC: Commenting
In SAP Analytics Cloud (SAC) you can integrate your BPC embedded planning models via the BPC Live-connection . This enables Live planning with your BPC models, the data updates (writeback) are made in real-time into the BPC embedded data providers, so there is no staging or duplication of data in SAC. Essentially you are leveraging the BPC embedded planning objects (data providers, input queries and business calculation functions) and only using SAC as a frontend user interface for planning and analysis.
In the previous blog of the BPC MOVE blog series, I presented how you can use the BPC Live-connection and consume the BPC embedded planning queries for building a data entry user interface in SAC.
In this blog I want to illustrate how you can leverage the BPC embedded planning sequences for triggering remote BPC business logic and how to incorporate them into SAC stories and analytics applications for building an end-to-end BPC Live planning application in SAC.
End-to-end BPC Live planning application in SAC
There is a simple BPC embedded planning example available in SAP BPC/BW systems, which follows a quantity-times-price approach for planning sales and contribution margin of vehicles across Europe, per Region and Product Category. This simple planning example contains the following BPC planning sequences:
Selective deletion of plan data per region (SSP_PS_DEL_01) Prefill/Initialize plan version per region by making a projection based on actual data (SSP_PS_INT_01) Validate plan sales quantity input, negative values are not allowed (SSP_PS_VAL_01)
For incorporating a BPC planning sequence in SAC, the corresponding SAC model with live data access to BPC embedded model must be available. See more information at the previous blog .
Work with BPC planning sequences in SAC stories
From the Insert area choose the Planning Trigger option (1), select the BPC Planning Sequence Trigger (2), choose the SAC model and the Planning sequence e.g. SSP_PS_DEL_01 (3), enter Label and Description (4), if there are input variables, you have the option to select “open automatically the variable prompt by triggering” (5), finally position and format the created push button in your SAC story similarly as with Data Action buttons (6).
Incorporate BPC planning sequence in SAC story
You can execute the assigned deletion BPC planning sequence by selecting the region (1) & (2). After execution, the impacted data points will be highlighted in yellow and these changes will be stored in a temporary technical version (planning buffer). They then have to be published (3) for writing back the changes in realtime into the BPC data provider.
Trigger BPC planning sequence in SAC story
Remark: Context-sensitive execution for providing the ability to pass story filter or input control values into BPC planning sequence variables is not available in SAC stories yet.
Work with BPC planning sequences in Analytic Applications
For maximizing user experience and satisfying complex business requirements like validations and specific user guidance, you can boost the user interface using Analytic Applications. In Analytic Applications, the related BPC planning sequence APIs support, the BPC planning sequence trigger without manually setting any variable values, do various operations on the variable values at runtime, execute multiple steps e.g. validate and publish data .
In the below application after selecting the region (1), you can execute the assigned validation BPC planning sequence and publish data with one step (2).
Trigger BPC planning sequence in Analytic Applications
In the below example the “Validate & Publish” button triggers the BPC planning sequence (SSP_PS_VAL_01) for checking negative plan sales quantity data entries and if the check is successful, data changes are published and are written back in realtime into the BPC data provider.
Trigger BPC planning sequence in Analytic Applications: Prevent publish data
Trigger BPC planning sequence in Analytic Applications: Validate and publish data
The following blogs explain how to publish data and pass input control to Data Actions with buttons (similar approach by using the BPC planning sequence APIs ) in Analytical Application.
With the new Optimized Story Experience the above Story and Analytic Application scenarios will be unified, see the link below:
Last but not least, you can execute BW/BPC calculation steps by triggering process chains in the BW backend system. Detailed information can be found in the blog link:
With the BPC Live-connection in SAC and with a few simple steps you can incorporate the BPC Embedded business logic into SAC stories and Analytic applications. Only minimun effort is required to modernize and unify your frontend user interface for planning and analytics. Any existing BPC planning application can be extended and combined with other use cases in the cloud in a unified way. It is worth mentioning that by leveraging the BPC Live-connection and the BPC Runtime license, we simplify the BPC customers transition journey to xP&A and to SAP Analytics Cloud by allowing them to move at their own pace, without disruption to their planning processes. This is something unique!
Check out the BPC MOVE blog series and this further information to learn more about BPC Live planning in SAP Analytics Cloud:
The SAP Note 2969947 provides you the latest information of the supported and unsupported planning functionalities when using an SAC Model based on a BPC Live connection. Enabling BPC Runtime-license: https://launchpad.support.sap.com/#/notes/3150518 Easily transition from BPC to SAC-P: https://www.sap.com/products/technology-platform/cloud-analytics/move-planning.html
Leave a Reply Cancel reply
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
- Planning Product
SAP Analytics Cloud
SAP was founded in 1972 as a business applications company. Today, the vendor has a turnover of €27.34 billion, employs more than 100,000 people and is one of the largest business software vendors in the world.
SAP’s analytics portfolio encompasses cloud and on-premises solutions for BI, analytics and enterprise planning. From a strategy perspective, SAP is investing heavily in innovation in the cloud while still supporting and developing its on-premises solutions. SAP’s analytics and EPM solutions are spread across different product lines. SAP Analytics Cloud (SAC) and the on-premises solution SAP Business Planning and Consolidation (BPC) are its core offerings for planning and budgeting. Both are supplemented by SAP S/4HANA Finance for Group Reporting for financial consolidation and close. Together with SAP BusinessObjects BI (on-premises), SAP Analytics Cloud also plays a central role in the company’s BI and analytics portfolio. Advanced analytics functionality is also available in SAP Analytics Cloud.
SAP Analytics Cloud, SAP’s strategic cloud offering and analytics platform, brings together capabilities such as BI and data visualization, planning and augmented analytics for different user roles into one integrated platform. With a large and growing development team, SAP Analytics Cloud is becoming richer in features such as application design, planning and predictive functionality as well as being enhanced with more than 80 prebuilt business content packages (e.g., solutions for finance, sales and marketing, HR and various industries). The product is fully web-based with an HTML5 web client and a Microsoft Office 365 Excel add-in. SAP Analytics Cloud has a modern and user-friendly UI and offers functionality for all individual planning activities including strategic, operational, functional and financial planning. It integrates with all major SAP enterprise applications (e.g., SAP S/4HANA, SAP HANA and SAP Data Warehouse Cloud). In addition to using it with its own data models, SAP Analytics Cloud can also be used as a front end for other SAP data sources in hybrid cloud scenarios (e.g., with SAP HANA, SAP BW/4HANA, etc.) without moving, caching or persisting the data into the cloud.
SAP BPC is SAP’s recommended product for those requiring an integrated on-premises planning and financial consolidation solution. As an additional front-end option, SAP BPC customers can combine SAP Analytics Cloud with the product’s planning engine. SAP Analytics Cloud can access SAP BPC’s planning model (data and structures) using a ‘BPC Live Connection’ without replicating data, thus providing write-back options for planning data directly into SAP BPC’s planning model in BW through write-back enabled queries.
User & Use Cases
Just 37 percent of SAP Analytics Cloud users are planning users – significantly below the survey average of 64 percent – reflecting the fact that SAP Analytics Cloud is essentially an integrated tool with planning as well as strong analytics functionality. This is also reflected in its reported use cases. Customers leverage SAP Analytics Cloud for operational planning (46 percent) and financial planning (44 percent). Here, planning takes place at different aggregation levels. SAP Analytics Cloud is particularly used for budgeting (49 percent) and forecasting (47 percent). Besides planning, customers mainly use SAP Analytics Cloud for dashboards/scorecards (81 percent), standard/enterprise reporting (78 percent), ad hoc query (71 percent) and data analysis (61 percent). Many also plan to use it for strategic planning (59 percent), financial planning (53 percent) and forecasting (50 percent) in the future.
SAP Analytics Cloud targets mid-sized and large companies across all industries. 58 percent of our sample of SAP Analytics Cloud customers come from large companies (more than 2,500 employees) with a median of 225 users (including 20 using planning functionality), but the mean of 1,398 users (215 for planning) indicates there are also several significantly larger implementations.
Product Usage (Planning)
Product usage (other), percentage of tool users, percentage planning users, number of product users, number of planning users, company size, current vs. planned use (planning use cases).
Current vs. planned use (besides planning)
Percentage of employees using SAP Analytics Cloud
Planning users (as a percentage of all users)
Total number of users per company
Planning users per company
Company size (number of employees)
Want to see the whole picture?
BARC’s Vendor Performance Summary contains an overview of The Planning Survey results based on feedback from SAP Analytics Cloud users, accompanied by expert analyst commentary.
- Register for a free sample Vendor Performance Summary download
- If you have any questions, feel free to contact us
HI, Can any one please suggest can we write back data to BW or HANA as we do in BPC and IP . Or data just sits in SAC and we need to read it
Note 2838883 - SAC BW Writeback - Part 1 · Note 2847623 - SAC BW Writeback - Part 2. For SAP BW 750, upgrade your system to SAP BW 750 Support Package 18, or
Got to your model and click on “Data Management” and Export the Data to OData Service. ... Then you can select the ADSOs which were defined in the
Follow these easy steps to do a successful writeback from SAC to BW without using flat files.
SAP has made it possible to do a writeback from SAC to BW in an easy way! Watch the video below to see how. Back in February we made an enhancement requests
Use SAC as front-end tool for planning input. Write-back to BW. S4/HANA and Embedded Analytics. •. Treasury & Tax frontrunners in Equinor on
In this blog post, I distinct the SAP Analytics Cloud (SAC) to the previous conventional frontend of the SAP planning product BPC.
This blog will walk through a Revenue and Cost Planning example and illustrate how to export and map that planning data from SAC into S/4HANA.
With SAC Planning, we can easily read data from ACDOCA, as well as easily send the planned data to ACDOCP. We do not need to use an extra standard solution to
In SAP Analytics Cloud (SAC) you can integrate your BPC embedded planning models via the BPC Live-connection. This enables Live planning with
into SAP BPC's planning model in BW through write-back enabled queries.