Exploring Live Models and Import Models

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Describe the key elements of import models and live models
  • Create a live model

Live Model

We have already discussed live vs. import connections. Models use those connections to reflect specific data from that data source. A live model simply uses a live connection for the data it represents. Since a live connection merely provides access to data, there is no data contained in a SAP Analytics Cloud live model. The model only points to the specific data in the live data source. Consequently, you cannot manipulate any data in the model; any data manipulation must be done in the source database/system.

In addition, you cannot write data to the model (because doing so would really be writing back to the original source system), so live models are analytic models. The single exception is a live model to BPC Embedded, but that is outside the scope of this course.

Because only SAP sources can be accessed via a live connection, a live model reflects only SAP data.

SAP Datasphere requires a connection be created in SAP Analytics Cloud, but no SAC model is necessary. Stories and analytic applications can access SAP Datasphere data directly.

The process of creating a live model to any SAP source is very simple:

  1. From the Navigation Bar choose Modeler.
    You may need to choose the . . . More option.
  2. Select Live Data Model.
  3. Choose the appropriate System, Connection, and Data Source in the Create Model from Live Data Connection dialog box.
  4. View the measures and dimensions.
  5. Save the model.

Import Model

An import model uses an import connection to import (copy) data from a source database or system into the SAP Analytics Cloud model. This means there are always two versions of the data – one version in the original data source and the copy in SAP Analytics Cloud. Because the data is copied into the model, if the original data source changes, the changes are NOT reflected in the model. But it is very likely that data in the original data source changes regularly, so you can schedule the import process to occur on a regular basis in order to keep the original data source data in sync with the model data.

In addition to being able to schedule the data import process, you can also manipulate the data in the SAP Analytics Cloud model. It is a copy, so none of the manipulations are reflected in the original data source. The data wrangling/preparation interface is user-friendly and fairly intuitive.

Regardless of the model type – live or import – most data preparation should be done within the original source database/system, including data optimization and data enhancement, before using the data in SAP Analytics Cloud.

Regardless of the style of model (analytic vs. planning) or type of model (live vs. import), the overall modeling work flow is the same.

Modeling Workflow

Create a Live Data Model Based on SAP HANA Data

Task 1: Create a live model

Business example

You need to access real time data from your SAP HANA on premise system for simple data analysis.

Task flow

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

  • Create a live data model in SAP Analytics Cloud
  • Connect to an SAP HANA on premise system and select a calculation view
  • Select order date as the time dimension
  • View the data in data analyzer

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

Login or Register