SAP Analytics Cloud can be integrated with many SAP systems, including SAP S/4HANA, the SAP BusinessObjects BI platform, and SAP BW. There are two options for integrating with SAP Systems:
- As a live data connection: no data will be stored on the cloud.
- As an import data connection: data will be stored in the cloud and updated periodically. NOTE: When using SAC as the interface for planning activities, data must be imported from S/4HANA, SAP BPC, or SAP BW.
Regardless of the connection option, most data preparation should be done within the SAP system, including data optimization and data enhancement, before using the data in SAP Analytics Cloud.
SAP Data Warehouse Cloud
SAP Data Warehouse Cloud (DWC) is SAP's software as a service (SaaS) offering that unifies data and analytics in a multi-cloud solution that includes data integration, database, data warehouse, and analytics capabilities. There are several ways to visualize data from DWC in SAC. As part of the embedded strategy of the SAP Analytics Cloud, each SAP Data Warehouse Cloud contains an SAP Analytics Cloud, embedded version. With this you can directly access the data that is available in the warehouse. If you already have an SAC system you can access DWC data via a live connection.
It is important to know that unlike integrating with other SAP systems, it is not required to create a data model in SAC. SAP Analytics Cloud can directly access analytical datasets within SAP Data Warehouse Cloud and use them as data sources for stories and analytic applications.
The SACMS1 course contains much more detailed information on creating models from SAP systems.
An Example of Integrating with SAP S/4HANA
A common example of integrating SAC with data from an SAP System is using SAC as the front-end for planning activities but retrieving the data from and storing the data in SAP S/4HANA. The figure Modeling Scenario outlines the overall process.
S/4HANA is an SAP ERP system.
Dimensions refer to master data and are the basis for analysis and planning activities. Sample dimensions in a planning scenario include account, time, version, product, customer, cost center, and company.
Why use SAC as the front-end for calculating and entering planning numbers? As a cloud-based product, anyone can access their SAC tenant from anywhere using only a web browser. This flexibility gives planners the freedom to work on their planning tasks any time from anywhere.