1/11/26, 6:31 PM Exploring Model Data Sources
Learning Browse Get Certified My Learning Subscribe Explore SAP
/ Browse / Courses / Exploring SAP Analytics Cloud / Exploring Model Data Sources
Exploring Model Data Sources
Objective
After completing this lesson, you will be able to describe the key elements of import and acquired data.
Live Data
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.
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.
[Link] 1/6
1/11/26, 6:31 PM Exploring Model Data Sources
Learning Subscribe
Note
SAP Datasphere requires a connection be created in SAP Analytics Cloud, but no SAP Analytics Cloud
/ Browse / Courses
model/ isExploring SAPStories
necessary. Analyticscan
Cloud / Exploring
access Model Data
SAP Datasphere Sources
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.
1. From the side navigation choose Modeler.
2. Select Live Data Model.
3. 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.
4. View the measures and dimensions.
5. Save the model.
[Link] 2/6
1/11/26, 6:31 PM Exploring Model Data Sources
Acquired
Learning Data Subscribe
An import model uses an import connection to import (copy) data from a source database or system into the
/ Browse SAP
/ Courses / Cloud
Analytics model.
Exploring This means
SAP Analytics that/ there
Cloud are always
Exploring two Sources
Model Data 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. As it is very likely that data in the original data source changes regularly, you can schedule the import
process to occur on a regular basis in order to keep the model data in sync with the original data source.
Schedule Data Import:
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 preparation interface is user-friendly and fairly intuitive.
[Link] 3/6
1/11/26, 6:31 PM Exploring Model Data Sources
Modeling
Learning Work Flow Subscribe
Regardless of the style of model (analytic versus planning) or type of model (live versus import), the overall
/ Browse modeling
/ Courseswork flow is the
/ Exploring same.
SAP Analytics Cloud / Exploring Model Data Sources
1. Identify your data sources
2. Decide to acquire data, use live data, or both. Things to consider in this decision include:
Performance
Security
Planning
Smart Predict
Necessary data wrangling
3. Create connections in SAP Analytics Cloud
4. For live data, create live models
5. For imported data
Create dimensions and import master data
Create models and import transaction data
6. Create stories
Note
For both model types – 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.
[Link] 4/6
1/11/26, 6:31 PM Exploring Model Data Sources
Learning
Personalize your learning Subscribe
Register Log in
Log in and track your growth over time
/ Browse / Courses / Exploring SAP Analytics Cloud / Exploring Model Data Sources
Next lesson
Was this lesson helpful? Yes No
Learning
Quick links
Download Catalog (CSV, JSON, XLSX, XML)
SAP Learning Hub
SAP Training Shop
SAP Developer Center
SAP Community
Newsletter
Learning Support
Get Support
Share Feedback
Release Notes
About SAP
[Link] 5/6
1/11/26, 6:31 PM Exploring Model Data Sources
Company Information
Learning Subscribe
Copyright
/ Browse / Courses / Exploring SAP Analytics Cloud / Exploring Model Data Sources
Trademark
Worldwide Directory
Careers
News and Press
Site Information
Privacy
Terms of Use
Legal Disclosure
Do Not Share/Sell My Personal Information (US Learners Only)
Cookie Preferences
[Link] 6/6