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

Objectives

After completing this lesson, you will be able to:

Create a live model with S/4HANA data
Create a live model with with HANA data
Create a live model with SAP Business Warehouse data
Create a live model using SAP BusinessObjects data

Overview

Live models are created with SAP data and are created in the same way, regardless of the SAP system. The only difference is the System Type, Connection, and Data Source you select in the dialog when you begin the creation process.

Your SAP Analytics Cloud system administrator typically creates the Connection, while your SAP source system team creates the Data Sources.

SAP S/4HANA

SAP S/4HANA Integration

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

As a live data connection: No data is stored on SAP Analytics Cloud.
As an import data connection: Data is stored on SAP Analytics Cloud and updated periodically. When using SAP Analytics Cloud as the interface for planning activities, data must be imported from S/4HANA.

SAP S/4HANA Data Sources for Models

You can create live data models to SAP S/4HANA Core Data Services Views or Queries.

SAP HANA

SAP HANA Integration

SAP Analytics Cloud is integrated with SAP HANA in two ways:

As a live data connection: Available for SAP HANA and SAP HANA Cloud.
As an import data connection: Available for SAP HANA.

SAP HANA Data Sources for Models

In SAP Analytics Cloud, you can create live models using HANA Calculation Views as a data source. Calculation Views allow definition of more advanced slices on the data available in the SAP HANA database. Live models based on HANA Calculation Views can improve story performance by delegating and moving data-intensive calculations to SAP HANA Cloud.

When working with live models for SAP HANA, there are three unique features:

You can declare a Time Dimension, allowing for the use of automatic time determination features in stories.
In the Measures tab, the aggregation settings can be adjusted in the live model.
In the Dimension tab, dimensions can be renamed, grouped, or hidden.

Live models in SAP HANA: Below, you can see a story table with time determination options for an SAP HANA live model. It allows for automatic time determination in stories.

SAP Business Warehouse

SAP Business Warehouse Integration

The Integration of an SAP Business Warehouse can be done in two ways:

As a live data connection: Available for SAP BW and SAP BW/4HANA.
As an import data connection: Available for SAP BW and SAP BW/4HANA.

SAP BW Data Sources for Models

You can create live data models to SAP BW Queries.

Supported SAP BW Query Elements in Live Models

The following SAP BW Query elements are supported in SAP Analytics Cloud models:

Time-dependent hierarchies.
BW Variables.
BW Variants and Personalization.
BW Structures.
Parallel processing of BW queries.

BW Hierarchy Support

Time dependent hierarchies are supported.
Time dependent hierarchy structures are supported.

BW Variable Support

Exit and authorization variables are supported.
Show booked values in the search help based on the setting in the BW query.
Merge/unmerge Prompts.

Parallel Processing Support

Only use where performance improvement is absolutely required.
Manage BW server resources carefully.

Measure/Dimension Support

For measures, you can change the following:

Descriptions.
Scale to be displayed as default (thousands, millions, etc.).
The decimal place defaults: This is preferable at the model level if measure reporting has a specific universal format (as in financial reporting), as opposed to always changing scale and decimals at the story level.

For dimensions, you can change the following:

Descriptions.
Create semantic groups of dimensions for easier navigation during story creation. This is advantageous in the case of SAP BW queries that have a large number of dimensions to choose from.

Note

Display and navigation attributes are not fully supported. You must manually change the attribute column in as a property classification.

SAP BusinessObjects

SAP BusinessObjects Integration

The Integration with SAP BusinessObjects can be done in two ways:

As a live data connection: Available for SAP BusinessObjects Universes and Web Intelligence documents.
As an import data connection: Available for SAP BusinessObjects Universes.

SAP BusinessObjects Data Sources for Models

Live models can connect to a SAP Business Objects Universe and to Web Intelligence documents, including any document variables (formulas).

Note

Web Intelligence Variables are not to be confused with SAP BW Variables. SAP BW Variables often render as prompts. Web Intelligence variables are simply calculations and formulas that have been defined with a name and will not prompt the user for any information.