Creating live models with SAP Business Warehouse data

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Create a live model with SAP Business Warehouse data

SAP Business Warehouse Integration

SAP Analytics Cloud and SAP BW, SAP BW/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 Business Warehouse can be done in two ways:

  • As a live data connection: no data will be stored in SAP Analytics Cloud.

  • As an import data connection: data will be stored in SAP Analytics Cloud and updated periodically.

Supported SAP BW elements in live models

The following SAP BW elements are supported in SAP Analytics Cloud 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.

Identify data for Business Warehouse models

Import data connection

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

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

Create a live data connection for BW models

If you need to create a live model to view data from BW, you must:

  1. Create a live model
  2. Select the BW live connection/system/query
  3. Save the live model and update the dimensions, if required
  4. Update the measures, if required
Steps to create a live model for BW.

A live data connection to SAP BW data:

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

Create a live model using SAP Business Warehouse data

Task 1:

Business example

Your company uses BusinessWarehouse and you would like to display some of your BW queries in SAP Analytics Cloud stories using live connections. As you need to use the BW data in multiple stories, you will create a live models.

Task flow

In this practice exercise, you will perform the following tasks:

  • Create a live model based on a SAP BW query with variables and a hierarchy
  • Create a live model based on a SAP BW query with structures
  • Create a story based on the models
  • Use the SAP BW variables to make your selections in the story
  • Create a variable variant

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

Login or Register