We have already discussed live versus 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 SAP BPC Embedded, but that is outside the scope of this course.
Because only SAP sources can be accessed using a live connection, a live model reflects only SAP data.
Note
SAP Datasphere requires a connection be created in SAP Analytics Cloud, but no SAP Analytics Cloud model is necessary. Stories can access SAP Datasphere data directly.Create a Live Model
The process of creating a live model to any SAP source is very simple as you can see from the summary of steps below. We will create a live model in the practice exercise in the next lesson.
- From the Navigation Bar choose
Modeler.
- Select Live Data Model.
- Choose the appropriate System Type, Connection, and Data Source in the Create Model from Live Data Connection dialog box. Remember, the Connection and Data Source are unique to your organization.
- View the measures and dimensions.
- Save the model.