Creating Live Models

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.

This lesson consists of four exercises, in each one you will complete the same task, creating a live model on one of the SAP systems discussed in this unit.

It's not necessary to complete every exercise. Simply choose the exercise that conforms to the specific SAP data source system you are using in your organization. If you are using more than one SAP data source system, then choose all that apply to you.

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

1. As a live data connection: No data is stored on SAP Analytics Cloud.
2. 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 Live Models: You can create live data models to SAP S/4HANA Core Data Services (CDS) views or queries.

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

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

SAP HANA Data Sources for Live 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 SAP 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:

1. You can declare a Time Dimension, allowing for the use of automatic time determination features in stories.
2. In the Measures tab, the aggregation settings can be adjusted in the live model.
3. 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.

The integration of an SAP Business Warehouse (SAP BW) can be done in two ways:

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

SAP BW Data Sources for Live Models: You can create live data models to SAP BW queries.

• SAP BW Query Element Support:
  • Conditions
  • Time-dependent hierarchies.
  • SAP BW variables.
  • SAP BW variants and personalization.
  • SAP BW structures.
  • Parallel processing of SAP BW queries.
• SAP BW Hierarchy Support:
  • Time dependent hierarchies are supported.
  • Time dependent hierarchy structures are supported.
• SAP BW Variable Support:
  • Exit and authorization variables are supported.
  • Show booked values in the search help based on the setting in the SAP BW query.
  • Merge/unmerge prompts.
• Parallel Processing Support:
  • Only use where performance improvement is absolutely required.
  • Manage SAP 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.

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

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

SAP BusinessObjects Data Sources for Live Models: Live models can connect to a SAP BusinessObjects Universe and to Web Intelligence documents, including any document variables (formulas).