Creating a Live Dataset
You want to create a live dataset using data from your SAP HANA
on-premise system.
Prerequisites
Ensure that a connection has been established between your SAP HANA
on-premise system and SAP Analytics Cloud. For more information, see
Live Data Connection.
Ensure that you have one of the following security roles: Predictive
Admin,BI Admin, or Admin.
Procedure
-
From the main menu, select .
-
Select Data from a data source.
The window Select a data source opens.
-
From the Connect to Live Data area, select your existing
SAP HANA Live Data Repository and fulfill the steps to
complete connection:
Information requested |
What does it mean |
1- Select a Data
Repository |
Select the Data Repository,
which has been set up to create your live datasets.
|
2- Select a table |
The existing schemas available for this
Data repository are
displayed. Select the one that points to the actual data
stored in your SAP HANA on premise
system. |
-
Give a name to your dataset in SAP Analytics Cloud and save
it.
The dataset is now created and appears in the
Files menu of SAP Analytics
Cloud.
Next Steps
As the data stays in your on-premise
SAP HANA system, the data is
available in real time: you don't need to manually upload the dataset each time you
update your data. Any data changes you make to your tables and SQL views in your
SAP HANA on-premise system appear immediately in the live dataset
stored in
SAP Analytics Cloud, as long as you do not change the list of
columns used. To update the predictions, you need only two steps:
-
Retrain your predictive model if you want to get it updated.
Note
This step
is recommended for Time series predictive models.
- Re-apply the updated predictive model to get the output SAP HANA
table updated. The updated predictions will be right-away visible into your
stories.
Note
When applying classification and regression predictive models,
make sure to select the exact same list of predictive outputs so that the
existing output table can be updated in
SAP HANA.