This repository contains the material for the SAP TechEd 2022 session called DA280 - Build an Integrated Planning Scenario with Data and Analytics Solutions.
In this session, we will build an end-to-end integrated planning application with SAP Data Warehouse Cloud and SAP Analytics Cloud using the bi-directional data transfer between the two solutions. Besides the data transfer, the session covers data modeling, including the data marketplace in SAP Data Warehouse Cloud, as well as the creation of a planning model with predictive analytics and the respective front end for data entry.
Energy prices are increasing continuously. Companies are worried about the direct impact on their results and cash flow. Therefore, we want to create an automated liquidity forecast with SAP Analytics Cloud's predictive analytics capabilities on top of internal financial and external data from SAP Data Warehouse Cloud.
To do so, we look for external data on energy prices in the Data Marketplace within SAP Data Warehouse Cloud. We add this data to our internal cash flow statement actuals and load it to SAP Analytics Cloud to serve as the basis for our new liquidity forecast.
The requirements to follow the exercises in this repository are:
-
SAP SAC tenant
-
SAP DWC tenant
The above requirements have already been met and have been pre-created by SAP. Follow this instruction to register for our tenants! The tenants will be available until December 16, 2022.
Apart from that, we recommend basic proficiency with modeling and story building in SAP Analytics Cloud and basic proficiency with SAP Data Warehouse Cloud. However, the exercises are suitable for everyone if the materials recommended in the 'Learn More' section are considered.
Exercise 0 explains the architecture of the exercises and provides information regarding each of the components. It is strongly recommended content but does not include hands-on exercises.
The hands-on exercises begin with Exercise 1.
Please note that SAP Analytics Cloud and SAP Data Warehouse Cloud perform best in Google Chrome.
Here you find direct jumps to the distinct exercises:
- Exercise 0 - Overview and Starting Point
- Exercise 1 - Combining External and Internal Data in SAP Data Warehouse Cloud
- Exercise 2 - Connect to DWC
- Exercise 3 - Copy planning model and load data
- Exercise 4 - Story Building
- Exercise 5 - Create a Smart Predict Scenario
- Exercise 6 - Create a Multi Action
- Exercise 7 - Delete version data before running the prediction
- Exercise 8 - Story Building & forecasting/planning
- Exercise 9 - Export to DWC
To learn more about SAP Analytics Cloud, refer to the following sources of information:
To learn more about SAP Data Warehouse Cloud, refer to the following sources of information:
- https://developers.sap.com/mission.data-warehouse-cloud-get-started.html
- https://community.sap.com/topics/data-warehouse-cloud/getting-started
To learn more about the bi-directional integration between SAP Analytics Cloud and SAP Data Warehouse Cloud for planning, refer to these sources of information:
- Blog post: Introducing the Bi-Directional Integration of SAP Data Warehouse Cloud and SAP Analytics Cloud for Planning
- Devtoberfest session
We posted some FAQs on the issues tab. If your question is not answered there, support for the content in this repository is available during the actual time of the online session via the broadcasting platform. After the online session, you may raise your question via the issues tab.
Copyright (c) 2022 SAP SE or an SAP affiliate company. All rights reserved. This project is licensed under the Apache Software License, version 2.0 except as noted otherwise in the LICENSE file.