Tell us what you think

We want to create the best possible experience for our learners. Your feedback helps us to improve the experience for everyone.

SAP Learning Journey

Creating live models with SAP Business Warehouse data

Objectives

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:

Create a live model
Select the BW live connection/system/query
Save the live model and update the dimensions, if required
Update the measures, if required

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

ExerciseStart Exercise

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

Continue to next lesson