Integrating with SAP Business Warehouse

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

After completing this lesson, you will be able to:

  • Access data from SAP Business Warehouse

SAP Business Warehouse 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.

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.

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.

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.

Supported SAP BW Elements in Live Models

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

Your company has been using BW for years and now you are implementing SAC. You would like to display some of you BW Queries in SAC Stories using live connections. You need to use the BW data in multiple stories so you will need to create a live model. For another BW Query, you will use data analyzer in more of an ad hoc scenario.

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