Introducing SAP Analytics Cloud

Accessing Data from SAP Systems

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Access data from SAP systems

SAP Universe Integration

SAP Analytics Cloud can be integrated with many SAP systems, including the SAP BusinessObjects BI platform.

The SAP BusinessObjects universe is one of the BusinessObjects BI platform's semantic layer options and is able to connect to almost any datasource, both SAP and non-SAP. With SAP Analytics Cloud's ability to connect to SAP BusinessObjects universes, BusinessObjects BI platform customers can leverage their on-premise BusinessObjects system with SAP Analytics Cloud's cloud-based modeling and analytics capabilities.

Most data preparation should be done within the universe, including data optimization and data enhancement, before using the universe in SAP Analytics Cloud.

General Considerations

Let's explore the SAP Analytics Cloud - SAP Universe connections.

Watch this video to learn how to integrate an SAP universe.

Create the Universe Connection

To connect to a universe, first create the appropriate connection. Once you have the connection, create a universe query to identify the data required by the SAP Analytics Cloud model.

Watch this video to learn how to create a model from an SAP BusinessObjects universe query.

Create an Analytic Model from a Universe

You need to acquire and wrangle data from a universe into an analytic New Model. The data only needs to be analyzed therefore, a planning model is not needed.

Task Flow

In this exercise, you will perform the following tasks:

  • Create an Analytic New Model
  • Import data from a universe
  • Wrangle data by concatenating the month and year data for the Date dimension
  • Create model-specific calculations
  • Create a Story using your model

SAP S/4HANA Integration

SAP S/4HANA is a complete enterprise resource planning (ERP) system with built-in intelligent technologies, including AI, machine learning, and advanced analytics. It helps companies adopt new business models, manage business change at speed, orchestrate internal and external resources, and use the predictive power of AI. With SAP Analytics Cloud's ability to connect to SAP S/4HANA, S/4HANA customers can leverage their on-premise system with SAP Analytics Cloud's cloud-based modeling and analytics capabilities.

The Integration with an S/4HANA system can be done in two ways:

  • 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 S/4HANA Live Data Connection

You can create live data connections to SAP S/4HANA systems using the Direct, Tunnel, and Cloud connection types. You can build stories based on released CDS views or leverage queries created by you.

In the figure SAP S/4HANA Live Data Flow we illustrate the data flow from S/4HANA to SAC. The View Browser Fiori app is used to access CDS views of all kinds.

Note

Use the Access Live SAP S/4HANA Data with a Model procedure to access the View Browser app.

Data Analyzer

Data analyzer is a predefined ready-to-run service for SAP Business Warehouse (SAP BW) queries, SAP HANA Live views, and SAP Analytics Cloud models for ad-hoc analysis. It uses SAP BW live connections, SAP HANA views and models created in SAP Analytics Cloud. All SAP BW queries, SAP HANA Live views and models can be accessed directly in the Select Data Source dialog and no additional model is created.

The steps to access the data analyzer are given below.

Data Analyzer - User Interface

Data analyzer contains a table, a filter area, and a builder panel with navigation capabilities to add and remove dimensions and measures from the table. In addition, you find a menu bar with a Refresh option and an Edit Prompts dialog (in case your datasource is designed for setting prompts).

Table formulas are available but calculated measures are not.

After you have drilled down to the data details according to your needs and analyzed your data, you might want to save this insight. For this, choose Save in the upper left corner of data analyzer. In the Save Insight dialog, select the file location (public or private) for your insight and enter a name and description for it.

Note
You can also test a CDS view from S/4HANA. In the data analyzer, connect to BW → S/4 → Log in with wss4 / Welcome1 → search for journal → If prompted, use company code 1010. In Fiori, this is the Journal Entry Analyzer. Launch Fiori from the SACP30 folder in the N drive with user s4h00-00 / Welcome1. It can be accessed with the Query Browser. The technical name of the view is C_GLLineItemsQ0001.

SAP Data Warehouse Cloud

As part of SAP HANA Cloud Services, SAP Analytics Cloud (SAC) and SAP Data Warehouse Cloud (DWC) are an essential part of the SAP strategy. The combination of both is a powerful tool that is designed for complex analytics scenarios based on hybrid system architectures.

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. To do so, an SAC connection must be created and SAC must be added as a trusted origin. For more information, use this link: https://blogs.sap.com/2020/05/19/how-to-connect-sap-analytics-cloud-and-sap-data-warehouse-cloud/.

It is important to know that 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 it as data source.

Note
As of February 2022, only live connections to DWC are available.

Access Data from SAP Data Warehouse Cloud

Steps

  1. Create a connection to DWC.

  2. In DWC, set the SAC tenant url as a trusted origin.

  3. In SAC:

    • Create a story
    • Go to the Data tab → Select Datasource → Select the SAP Data Warehouse Cloud live connection. (in the training system the DWC connection should already be set up. If not, use Host: sapeducdwc.eu10.hcs.cloud.sap Port: 443 Authentication Method: SAML Single Sign On.
    • Log into DWC if needed (Note for instructor: see the SSG for the user & password).
    • Select a DWC workspace (such as Business Area Sales in the training server) → Select a DWC Analytical Data Set (such as Sales__Country in the training server).
    • Add a table and configure it with product id in the columns.
    • Save the story.

SAP Business Warehouse (SAP BW) Integration

SAP Analytics Cloud and SAP BW, SAP BW/4HANA

As with SAP BusinessObjects universes and SAP S/4HANA, SAP Analytics Cloud integrates seamlessly with SAP Business Warehouse (SAP BW) to make the most of your existing investments. And the Integration of an SAP universe can be done in two ways:

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

Live Data Connection

When using a live data connection to SAP BW, you have the following advantages:

  • Accesses SAP BW features that cannot be accessed through standard SQL or MDX query interfaces.
  • Leverages the SAP BW metadata without additional modeling.
  • Re-uses existing authorization concepts.
  • Connects to SAP BW, as well as generated SAP HANA views.

Import Data Connection

When using an imported data connection to SAP BW, you have the following advantages:

  • Uses existing SAP BW queries to securely import your data into the cloud.
  • Applies SAP Analytics Cloud native data security concepts.
  • Leverages the calculation engine of SAP HANA to allow for additional analytic use cases.

The process of importing data from SAP BW to SAC is illustrated in the figure SAP BW Import Workflow.

Watch this video to learn how to create a model from an SAP BW query.

Importing data from SAP BW has the following prerequisites:

  • The SAP Business Warehouse (BW) system is version 7.3x or higher, or SAP BW/4HANA system, SP4 or higher.
  • SAP BTP Connectivity Cloud Connector is installed.
  • SAP Analytics Cloud agent is installed.

Supported SAP BW Elements

The following SAP BW elements are supported in SAC stories:

  • Time-dependent hierarchies
  • BW Variables
  • BW Variants and Personalization
  • BW Structures
  • Parallel execution of BW queries

Let's go into the details of each feature of live data connectivity to SAP BW.

Access SAP BW Live Data

Task Flow

In this exercise, you will perform the following tasks:

  • Create an SAP Analytics Cloud model based on an SAP BW live connection and an SAP BW query with variables and a hierarchy.
  • Create a story based on the model.
  • Use the SAP BW variables to make your selections in the story.
  • Use Data Analyzer to analyze the data in a BW query with two structures.

Save progress to your learning plan by logging in or creating an account