In this post, we cover one common source for error — using live vs data import models. You will learn what are the differences between the two and how you can set up your content correctly.
Import vs. Live
In SAP Analytics Cloud, there are two types of connections:
- import data connections
- live data connections
Once a connection is established, data can be imported to a new or existing model. For data sources that have a live connection, a model can be created based on the live connection and the data will be read in real time.
Also, the content documentation has a sub-chapter called “Data Source Connection and Integration” for every model with a table where the recommended connection type and connection source are mentioned. Furthermore, the technical name of the model includes “IM” when there is an import data connections vs “LH” for Live Hana connection and other abbreviations for other data connections.
Another quick way to find out which types of models the package is for is to see if there is a ‘Include Data’ option. Every data model that has imported demo data has an ‘Include Data’ checkbox in the content library. In the SAP Banking package, for instance, we have a mix of both Data Import and Live Data Models, which can be seen in the image below.
Import data models
When importing data models from the content library, you have the advantage of having demo data included with the content package. You can immediately get started with the content and get an idea of the stories and the features included.
Two of our content packages come with predefined connections: SAP Business ByDesign and SAP Travel & Expense – Concur.
When importing those connections, you will notice that you still need to set them up. Check out the content documentation for more details.
For Travel and Expense, you will find the instructions in the chapter TE: Architecture and Abstract, which will guide you through the following steps:
“Go to Menu > Connection, select the connection “Concur Tenant (Data acquisition via Concur API connector)” and edit the connection parameters Key and Secret as provided by your Concur web service administrator (See help center topic “Import Data Connection to Concur”).”
“To import data into the models, go to Menu > Browse > Models, select the respective model, click on View More in the column Data Sources and click Import Data to start the import via the “Concur Tenant” connection. You can edit the import options and the schedule settings by clicking on the target name. It is recommended to use the import method Clean and Replace.”
For the SAP Business ByDesign package, you can follow similar steps.
Updating content or downloading additional packages might overwrite customer enhancements or changes to content objects or even loose customer data. Please read the chapter 3.2 of the content documentation carefully to avoid accidental loss of customer enhancements and data.
Live data models
Live data models require one additional step before importing the content: you have to have a connection with the same name in place in order to see data in the stories and dashboards after importing the content.
If you do not have that connection, you will still be able to import the content but you will receive an error message, when opening the model or story:
For example, when opening the model SAP__FS_LH_CLIENTEXPOSURES, you receive the following error message:
When opening the story SAP__FS_GEN_LIQUIDITYMANAGEMENT, you will notice that a chart says “Data cannot be retrieved from the data source”.
You will find the instructions on how to establish the connection in the content documentation.
For example, for Banking it is described in the chapter FS Banking: Stories > SAP Banking: Liquidity Management (SAP__FS_GEN_LIQUIDITYMANAGEMENT):
“This story is based on a live data connection of type “SAP HANA”. The story will therefore not show any data unless a suitable connection “SAPLM” has been created. The connection may be set up prior or after the import of the content package SAP FS Banking. If the connection does not exist when the content package is imported, the live models will be imported with warnings. They will be active, but unusable until the connection has been created. The connection has to have the name “SAPLM”. Enter a suitable description. Specify the connection details for the SAP Liquidity Management backend system and provide the required credentials. Depending on your specific data, the layout in the story SAP Banking: Liquidity Management may have to be adjusted (filter values, number scaling, etc.) “