One of the things that was on my wish list for some time is to use SAP Lumira 2.0 Designer with a streaming data source. Now that streaming data has become more and more mainstream (think IoT devices or certain web-services), the use case for streaming data sources also gets more viable and apparent. With a streaming data source, the data “streams” continuously into a dashboard. As such, your visualizations on it will change and adjust permanently. The use cases vary from monitoring a machine’s temperature to reviewing the number of ongoing calls in a data center or even watching stock prices in live-mode, to mention a few. Time to sort out streaming data sources with SAP Lumira 2.0 Designer and test it.

Event Stream Processing

SAP Lumira 2.0 Designer allows you to use a streaming data source as a source for analyzing. This functionality was also available in its predecessor, SAP BusinessObjects Design Studio. To make use of it, you need an event stream processor engine to handle the data as it flows in. I used SAP Event Stream Processor (SAP ESP).

Installing SAP ESP is not too difficult and I started with making a separate user to run my streams. SAP ESP is project-based and initially I took one of the sample projects coming with the software. This sample project uses a random data generator, but of course in real-live situations you’d use one of the streaming connectors available. After compiling my project and starting some of the required services, the data starts streaming and can be monitored from within SAP ESP all ready.

There is a very good whitepaper  you can read on SAP Event Stream Processor explaining how it works, what needs to be set up, and what are the prerequisites.

Setting up SAP Lumira 2.0 Designer

SAP Lumira 2.0 Designer made a big improvement when it comes to ease of dashboard development. If you want to know more, check out my blogs, Why Interoperability between BI Styles and Use Cases Is a Big Deal and Why Interoperability Rocks with SAP Lumira 2.0 Enterprise Dashboard.

For now I will just sum up the step-by-step (see a video demo below):

  1. Ensure your event stream processing engine is running. I used SAP Event Stream Processor.
  2. Open your SAP Lumira 2.0 Designer application or create a new one.
  3. Go to your Outline section and add a new data source. Choose Custom Data Source -> Streaming Data Source
  4. Select your streaming data source and go to the Additional Properties
  5. Apply the Host (LocalHost in my case) and the port number. You’ll find the portnumber in your ESP engine.
  6. Use the User as set up in your ESP engine with the accompanying password
  7. Select the Topic you defined in your SAP ESP project
  8. Within the Additional Properties there are three sub-tabs. Now click the second one where you can define for the streaming attributes which ones are identified as measures and which ones as dimensions. Apply this correctly
  9. Within the Additional Properties there are three sub-tabs: click the third one and select what dimension(s) and measure(s) you require for your data source
  10. Repeat Step 8 and 9 by creating additional streaming data sources
  11. Create a chart on your dashboard and assign the streaming data source
  12. Off you go!

Demo SAP Lumira 2.0 Designer Using a Streaming Data Source

In this video, I go through all of the above mentioned steps. You also see some insights on SAP Event Stream Processor using the Studio module. Have fun!

This post originally appeared on Iver van de Zand’s blog and has been republished with permission.