Modeling & SAP System Integration

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

After completing this lesson, you will be able to:

  • Create a live model using SAP HANA data

SAP Analytics Cloud Models

Styles of Model

A model represents a table of data. Example: Sales, Expenses, and HR and so on.

SAP Analytics Cloud recognizes the following styles of models:

Planning Model

Planning models are preconfigured with dimensions for time and version. They offer support for multi-currency and security features at the level of both model and dimension. When working with a planning model in a story, users with planning privileges can create their own versions of model data. These users can also write data to the model by typing new values, copying and pasting data, and using data actions.

Analytics Model

Unlike the planning model, the analytics model does not support versions and does not require a time dimension. It is used for stories and analytic applications that are read-only, for data presentation and analysis purposes.

SAP Analytics Cloud Data Sources

The figure below shows the comparison between datasets, planning models, and analytic models. Note that the model information shown here is for the new model type.

Note

Both datasets and models can be used as data sources in stories.

A shareable live dataset can be created for SAP HANA. Live datasets can also be created from a story based on SAP Data Warehouse Cloud.

Creating an SAP Analytics Cloud Model

The features of SAC models are as follows:

  • Transparency of data

  • Re-usable

  • Data can be enhanced

  • Required for planning

  • Flexible: Can be used in various data integration scenarios

Watch this video to learn about the data source options for creating a simple SAP Analytics Cloud model.

Viewing Options

When creating a model, SAP Analytics Cloud has two viewing options:

  • Structure View

  • Data Foundation View

Let's go into the details of each viewing option.

Structure View

The Structure view shows you a star schema diagram representing the contents of your model. This view helps you to visualize how your fact data (measures), attributes, and properties all relate to each other. At a glance, you can see the model's dimensions surrounding the data foundation.

Additionally the dimension box shows you more information based on the dimension type. For example, the version dimensions shows how many public versions there are, and whether there are any private versions. For date dimensions, you can see the information about granularity and default hierarchy, and (if added) whether the Fiscal Year setting has been applied.

If you want to add a new dimension or existing dimension to your model, you can do that from the toolbar, or from the Schema view.

Data Foundation View

The Data Foundation view shows you the fact table containing the raw, non-aggregated transactional data loaded into your model. The total number of results is the total number of rows of data, not including any filtering you have applied, across all versions.

In planning models, you can also switch between the different public versions of your data, for example, to see if data exists for a selected version

The Structure and Data Foundation views work together with the dimension list and details panel to give you a consistent picture of your data. For example, if you select a dimension in the schema diagram, the other views all focus on that dimension.

SAP System Integration

SAP Analytics Cloud can be integrated with many SAP systems, including SAP S/4HANA, the SAP BusinessObjects BI platform, and SAP BW. There are two options for integrating with SAP Systems:

  • As a live data connection: no data will be stored on the cloud.
  • As an import data connection: data will be stored on the cloud and updated periodically. NOTE: When using SAP Analytics Cloud as the interface for planning activities, data must be imported from SAP S/4HANA, SAP BPC, or SAP BW.

Regardless of the connection option, most data preparation should be done within the SAP system, including data optimization and data enhancement, before using the data in SAP Analytics Cloud.

SAP Data Warehouse Cloud

SAP Data Warehouse Cloud is SAP's software as a service (SaaS) offering that unifies data and analytics in a multi-cloud solution that includes data integration, database, data warehouse, and analytics capabilities. There are several ways to visualize data from SAP Data Warehouse Cloud in SAC. As part of the embedded strategy of the SAP Analytics Cloud, each SAP Data Warehouse Cloud contains an SAP Analytics Cloud, embedded version. With this you can directly access the data that is available in the warehouse. If you already have an SAP Analytics Cloud system you can access DWC data via a live connection.

It is important to know that unlike integrating with other SAP systems, it is not required to create a data model in SAP Analytics Cloud. SAP Analytics Cloud can directly access analytical datasets within SAP Data Warehouse Cloud and use them as data sources for stories and analytic applications.

The SACMS1 course contains much more detailed information on creating models from SAP systems.

An Example of Integrating with SAP S/4HANA

A common example of integrating SAP Analytics Cloud with data from an SAP System is using SAP Analytics Cloud as the front-end for planning activities but retrieving the data from and storing the data in SAP S/4HANA. The figure Modeling Scenario outlines the overall process.

Note
SAP S/4HANA is an SAP ERP system.

Dimensions refer to master data and are the basis for analysis and planning activities. Sample dimensions in a planning scenario include account, time, version, product, customer, cost center, and company.

Why use SAP Analytics Cloud as the front-end for calculating and entering planning numbers? As a cloud-based product, anyone can access their SAC tenant from anywhere using only a web browser. This flexibility gives planners the freedom to work on their planning tasks any time from anywhere.

Create a Live Data Model based on SAP HANA Data

Business Example

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

Task Flow

In order to do this, perform the following steps:

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

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