At the upcoming “DSAG (German SAP User Group) Jahreskongress 2016” I have the chance to present how easily you can work in hybrid (cloud-to-on Premise) SAP landscapes.
In this blog i will show you how easily you can visualize your SAP HCP IoT Data with SAP BusinessObjects Cloud.
Since the july release the OData adapter was introduced in SAP Business Objects Cloud What’s New in SAP BusinessObjects Cloud and SAP Digital Boardroom – July/August 2016
Please check also this nice blogs, which has me inspired to show the possibilty to watch your IoT data in SAP BusinessObjects Cloud:
And additional my previous blogs about SAP HCP IoT in combination with SAP HCP Integration Service (Data Services)
To fetch your IoT data open the URLfrom your BOC tenant:
And create an new connection to your SAP HCP:
Click the + button and add a new “Import Data Connection” and choose OData as type:
Provide/Select the following details:
- Connection Name: <your connection name>
- Description: <your description>
- Data Source Type: <OData Services>
- URL: https://<host>/com.sap.iotservices.mms/v1/api/http/app.svc
- User: <your_suser>
- pw: <suser_pw>
Aquirre and Model your HCP IoT Data
Switch in the BOC to the Modeler an define a new model.
Choose “Get data from an app”:
In the next step choose OData Services as source:
Define your Data Model and create a new query:
Enter a name and a description for your query and select your HCP IoT table which you want to use:
In the upcoming next screen build your query an select the required fields, in my example i use C_TIMESTAMP, C_LATITUDE and C_LONGITUDE.
Futhermore i define i filter that i only want to get my favorite data.
After you start the import, you are able to see your data as selected:
Convert your Data:
For my sceanario i need to transform my data, this is required because i want to use the coordinates in a BOC for Geo Map.
- Dublicate the C_ALTITUDE column because i wnat to use this later for my location identifier
- create the required location based on the C_LATITUDE and C_LONGITUDE:
As result you get a new colum from type location:
The last step in the BOC modele is now to save the model with a name of you choice an press “Create Model”:
In the overview you can now see your created model:
Create your Story
Now it´s time to visualize your IoT data, for rthis switch to the Stories perspective in BOC and create a new story (select Add Canvas):
In the next upcoming screen choose “Chart” as object:
Select your previously created data model as source:
Afterwards you can now create your visualization:
Add a Geo Map:
Now we need to create a new layer:
- click on the “Add Layer”
- select your data source
- select you location dimension and optional change the color, the map etc.:
As result you can now see your IoT data:
Ypu can now scroll into your map and get more details for a specific selection.
Fo example here you can see there was an traffic jam:
I think you can see how easily you can work with your IoT Data and with SAP HCP and SAP BusinessObjects Cloud.
Stay tuned in the next blog I will show you how can you fetch the SAP HCP IoT data via SAP HCP Integration Services and push this to an SAP Gateway OData service to store my data in an OnPremise HANA DB.
Additionally…..sorry it´s composed in German ;o) our session about this stuff: