Skip to Content
Author's profile photo Fabian Lehmann

Visualize your IoT Data with SAP Analytics Cloud

Introduction

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 Analytics Cloud (SAC) and formerly known as SAP BusinessObjects Cloud (BOC).

Since the July release the OData adapter was introduced in SAP Analytics Cloud What’s New in SAP Analytics Cloud and SAP Digital Boardroom – July/August 2016

Please check also this nice blogs, which has me inspired to show the possibility to watch your IoT data in SAP Analytics Cloud: 

The Easiest Way to Stream your iPhone’s Sensor Data to HANA Cloud Platform

From Wroclaw to Berlin and back: IoT analysis with SAP Lumira via jdbc

From Wroclaw to Berlin and back with SensorPhone and SAP HCP IoT

Additional my previous blogs about SAP HCP IoT in combination with SAP HCP Integration Service (Data Services): 

Use SAP HCP IoT Services and HCP Integration Services (HCI-DS) to get your Sensor Data – Part 1

Use SAP HCP IoT Services and HCP Integration Services (HCI-DS) to get your Sensor Data – Part 2

Use SAP HCP IoT Services and HCP Integration Services (HCI-DS) to get your Sensor Data – Part 3

Let´s start:

To fetch your IoT data open the URL from your BOC tenant:

boc_01.PNG

And create a new connection to your SAP HCP data source:

boc_02.PNG

 

Click the + button and add a new “Import Data Connection” and choose OData as type:

boc_03.PNG

boc_04.PNG

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>

Acquire and Model your HCP IoT Data

Switch in the SAC to the Modeler and define a new model.

Choose “Get data from an app”:

boc_05.PNG

In the next step choose OData Services as source:

 

boc_06.PNG

 

Define your Data Model and create a new query:

 

boc_07.PNG

Enter a name and a description for your query and select your HCP IoT table which you want to use:

 

boc_08.PNG

In the upcoming next screen build your query and 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.

 

boc_09.PNG

After you start the import, you are able to see your data as selected:

 

boc_10.PNG

 

 

Convert your Data:

For my sceanario i need to transform my data, this is required because i want to use the coordinates in a SAC for Geo Map.

 

  1. Duplicate the C_ALTITUDE column because i wnat to use this later for my location identifier
  2. create the required location based on the C_LATITUDE and C_LONGITUDE:

 

boc_11.PNG

 

boc_12.PNG

 

As result you get a new colum from type location:

boc_14.PNG

 

The last step in the SAC modeler is to save the model with a name of you choice and press “Create Model”:

 

boc_16.PNG

In the overview you can now see your created model:

 

boc_17.PNG

Create your Story

 

Now it´s time to visualize your IoT data, for this switch to the Stories perspective in SAC and create a new story (select Add Canvas):

 

boc_19.PNG

In the next upcoming screen choose “Chart” as object:

 

boc_20.PNG

 

Select your previously created data model as source:

 

boc_21.PNG

 

Afterwards you can now create your visualization:

 

boc_22.PNG

 

Add a Geo Map:

 

boc_23.PNG

boc_24.PNG

Now we need to create a new layer:

 

  1. click on the “Add Layer”
  2. select your data source
  3. select you location dimension and optional change the color, the map etc.:

boc_25.PNG

 

As result you can now see your IoT data:

 

boc_26.PNG

 

You can now scroll into your map and get more details for a specific selection.

Fo example here you can see there was a traffic jam:

 

boc_27.PNG

 

Conclusion

 

I think you can see how easily you can work with your IoT Data and with SAP HCP and SAP Analytics 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:

 

Hinweis_DSAG_awe_16_08_01 (002).jpg

 

Cheers,

Fabian

Assigned Tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Martina Mohr
      Martina Mohr

      cool, thanks!

      Author's profile photo Murali Shanmugham
      Murali Shanmugham

      Hi Fabian,

      Thanks for posting on this topic. Very clear and easy to follow. I actually tried this few days back using IoT Services. I was disappointed that the frequency to load new data (using the OData adapter) is just in days. When we talk about IoT, we need things in real time. I am hoping this feature will be added.

      Cheers,

      Murali

      Author's profile photo Fabian Lehmann
      Fabian Lehmann
      Blog Post Author

      Hi Murali,

      total agree with you, this one must be changed. i´am wondering too if i set up the repetion of my data query.

      cheers,

      fabian

      Author's profile photo Murali Shanmugham
      Murali Shanmugham

      Just in case someone wants to know how to schedule a regular import of the IoT data into BOC, below is the settings.

      /wp-content/uploads/2016/08/333_1014714.png

      Author's profile photo Moya Watson
      Moya Watson

      Excellent work - thanks for stepping us through this!

      Author's profile photo Sergio Guerrero
      Sergio Guerrero

      wow - awesome share.. keep up the great work.  great blog

      Author's profile photo Former Member
      Former Member

      Thanks for sharing. However I have a question. How could we create like a geospatial model in HCP to consume it in Business Objects Cloud? We already have latitude and longitude but we don't know what to do to create that model.

      Thanks in advance!

      Author's profile photo Moya Watson
      Moya Watson

      Robert Russell has done a lot of work with geospatial as well - maybe there are some insights here that could help? My Session At Las Vegas Teched 2016: Getting Started with Geospatial Topics on SAP HANA Cloud Platform for Free

      Author's profile photo Former Member
      Former Member

      Thank you Moya Watson, it looks really good 🙂

      Author's profile photo Former Member
      Former Member

      Very nice blog! One Question

      How did you manage to load a timestamp with format YYYY-MM-DD HH:MM:SS. I try to build a model from a flat file and I can not select this format...

      Author's profile photo Andreas Gautsch
      Andreas Gautsch

      Hi Fabian!

      Is there a restriction on the trial version. When I open the menu for the Import Data Connection I only see an entry for SuccessFactors, or do I oversee something.

      Greetings, Andreas

       

      Author's profile photo Fabian Lehmann
      Fabian Lehmann
      Blog Post Author

      Hi Andreas,

      yes, looks like that this is an restriction on the trial instance.

      As u can see in my screen (partner boc tenant), there are a lot of other including OData connections possible.

      br,

      fabian

      Author's profile photo Andreas Gautsch
      Andreas Gautsch

      Thanks for the clarification,

      br, Andreas

       

      Author's profile photo Teemu Jokinen
      Teemu Jokinen

      Great work, thank you!

      Author's profile photo sarthak srivastava
      sarthak srivastava

      Hi Fabian Lehmann ,

       

      Is this option->"Get Data from an App" deprecated now?

       

      Thanks,

      Sarthak Srivastava