Establishing Live Data Connection to HANA Views From SAP BusinessObjects Cloud – From Sensor to Cloud – Part 3
This is the 3rd and final part of the From Sensor to Cloud tutorial series.
In this tutorial, we will create a Live Data Connection in SAP BusinessObjects Cloud to the HCP view we created. We will create a model based on this connection and make a simple chart to visualize the data.
- You have prepared views in HCP (or you have completed Part-2 of this tutorial series)
- You have access to an SAP BusinessObjects Cloud Account
1 – Inside SAP BusinessObjects Cloud, go to Connections.
2- Create a Live Data Connection
3 – Enter Live Data Connection Details. You can see information such as landscape host in Part 2 of this tutorial series. If you have a trial HCP account, select trial for the landscape host. If all goes well, you will see a confirmation that the connection to the HCP account was established.
4 – Now, we will create a model based on the HCP view in the HCP account that we connected to. We can then consume this model in any story or chart inside SAP BusinessObjects Cloud.
5 – Enter the model details. Select the calculation view you created on HCP in Part-2 of this tutorial series.
6 – Select NONE as the aggregation type so that we can see the raw data. You can modify the aggregation type in order to achieve different aggregations of data.
7 – We are almost done. We will now create a story and a chart based on this model.
8 – Insert a chart.
9 – Select the model we created as the data source.
10 – Choose the specified options for the chart and our data is now visualized.
Every time you refresh or re-load this story, the data in the chart will be updated to reflect the latest data stored in HCP.
This is the last part of a 3-part tutorial. Here are the other parts: