SAP Lumira is a desktop software that allows you to build easily interactive graphics  from your data sets.

SAP Lumira helps you to prepare and pre-process the input data, create visualizations with different types of graphics and to prepare stories pinpointing your the conclusions of  your analysis. All in a user-friendly drag and drop environment.


SAP Lumira delivers faster time-to-insight in a repeatable, self-service way

SAP Lumira Personal Edition is free of charge and can be used to load data from Excel or .csv files.

You can download SAP Lumira  Personal Edition  from this link

With SAP Lumira Standard Edition you can additionally:


    • Connect to database servers
    • Perform analysis in live data with SAP HANA

SAP Lumira use case example

In this example we use SAP Lumira to visualize the date from a .csv file that contains the results of some network connectivity checks:


One server “serverA” is connected via a WAN to three different servers “host1″ , “host2″ and “host3″. The connection fails more often than expected.


We setup a mechanism based in “ping” executable that continously test the three servers. and store the result in the result.cvs file as:


[…]
host1;2013-11-27;12.45.43;0
host1;2013-11-27;12.46.42;0
host1;2013-11-27;12.47.41;0
host1;2013-11-27;12.48.41;0
host1;2013-11-27;12.49.40;0
host1;2013-11-27;12.50.39;0
[…]
host2;2013-11-27;12.45.43;0
host2;2013-11-27;12.46.42;100
host2;2013-11-27;12.47.41;100
host2;2013-11-27;12.48.41;100
host2;2013-11-27;12.49.40;100
host2;2013-11-27;12.50.39;0
[…]
host3;2013-11-27;12.45.43;0
host3;2013-11-27;12.46.42;1
host3;2013-11-27;12.47.41;3
host3;2013-11-27;12.48.41;0
host3;2013-11-27;12.49.40;1
host3;2013-11-27;12.50.39;0
[…]


Each line in the file contains info about the target host being tested, the date and hour (one test me minute) and the result of the test as percentage of packets loss detected in the test.


So 0 stands for 0% packet loss (all OK) , 100 means 100% packet loss or connection was not available during that period and other values in between show the quality of the line.


We add more detailed info on how we implemented this test in the anex at the end of the post.

This result.csv file is the input into SAP Lumira.

Preparing the data

    • We start SAP Lumira in oir PC and go to File -> New ->
    • Then we select CVS and the the “result.csv” file:


http://www.webdso.com/wp-content/uploads/2013/11/pic9.jpg


    • Then go to “Prepare” tab and rename the columns as “host” , “date”, “time” and “packet_loss”:

http://www.webdso.com/wp-content/uploads/2013/11/pic10.jpg

http://www.webdso.com/wp-content/uploads/2013/11/pic11.jpg

  • We rename the measure automatically created to “plm”:
  • Also change agregation from “Sum” to “Average”:

http://www.webdso.com/wp-content/uploads/2013/11/pic12.jpg

http://www.webdso.com/wp-content/uploads/2013/11/pic13.jpg

    • We convert  column “date” to type date selecting the propoer date format “YYYY-MM-DD”.  A new column is crreated “date(2)” and treated as a date.


http://www.webdso.com/wp-content/uploads/2013/11/pci14.jpg

Creating the first visualization


Now we go to the “Visualize” tab:


We drag & drop the measure packet_loss to “measures”, the attribute time to “attributes” and the attributes “host” and “date” as filters (selecting as filter host=”host1″ and date “25.11.2013″:


http://www.webdso.com/wp-content/uploads/2013/11/pic15.jpg

We select graphic of type “Line chart”.


As result we see how the connectivity behaved that day for host “host1″.

http://www.webdso.com/wp-content/uploads/2013/11/pic16.jpg

Then we “save” the view.


Now we can go to to the “Compose” tab, drag & drop our view into the first board of our story.

We can also rename and add text or images to the board.


http://www.webdso.com/wp-content/uploads/2013/11/pic17.jpg

Creating interactive boards

Now we create a second visualization under “Visualize” tabby clicking “Add new visualization”.


Now we add again “plm” as measure and we add “time” , “date(2)”and “host” as attributes (order matters) and select type og graphic (line):


http://www.webdso.com/wp-content/uploads/2013/11/pic20.jpg

We are not able to see any graphic because “the maximum number of 10.000 points has been reached”. We save and go to “Compose” tab.


We add a new board and drag&drop the new view.


We add “host” and “date” as controls (drag&drop):


http://www.webdso.com/wp-content/uploads/2013/11/pic21.jpg

Now we have an interactive board. We can display the graphic for several hosts and days by activating the controls.

Annex

These are the Unix scrips used to obtain the input data.

$ cat test_ping.sh

#!/bin/ksh

### test connectivity with ping ###

if  [ $# -ne 1 ]

then

echo "Usage: $0 IPAddress"

exit 1

fi

IP=$1

echo Testing ping for IP $IP

c=1

while [ $c -eq 1 ]

do

DATE=`date +%F`

TIME=`date +%H.%M.%S`

log_file=test_ping_v22-$IP-$DATE.log

#echo $log_file

echo Testing pingv22 packets $DATE $TIME $IP >> $log_file

ping -c 60 -v $IP >> $log_file

done

This Unix script is continously executing against the target server.  The ping command executes 60 tests (one per second).

We run the script in background once per target host that we are monitoring:


$ test_ping.sh host1 &
$ test_ping.sh host2 &
$ test_ping.sh host3 &


As result we have one log files per target host and per day with the raw results of the test:


test_ping_v22-host1-2013-11-26.log
test_ping_v22-host2- 2013-11-26.log
test_ping_v22-host3-2013-11-26.log


$ cat test_ping_v22-host1-2013-11-26.log


[…]
64 bytes from 10.2.13.20: icmp_seq=56 ttl=118 time=42.0 ms
64 bytes from 10.2.13.20: icmp_seq=57 ttl=118 time=42.0 ms
64 bytes from 10.2.13.20: icmp_seq=58 ttl=118 time=42.3 ms
64 bytes from 10.2.13.20: icmp_seq=59 ttl=118 time=42.3 ms
64 bytes from 10.2.13.20: icmp_seq=60 ttl=118 time=42.1 ms
— host1 ping statistics —

60 packets transmitted, 60 received,

0% packet loss, time 59080ms
rtt min/avg/max/mdev = 41.755/42.218/43.780/0.429 ms
Testing pingv22 packets 2013-11-27 00.01.27 host1
PING host1 (10.2.13.20) 56(84) bytes of data.
64 bytes from 10.2.13.20: icmp_seq=1 ttl=118 time=42.3 ms
64 bytes from 10.2.13.20: icmp_seq=2 ttl=118 time=41.7 ms
64 bytes from 10.2.13.20: icmp_seq=3 ttl=118 time=42.8 ms
64 bytes from 10.2.13.20: icmp_seq=4 ttl=118 time=42.2 ms
[…]

Then we use the following command and these two auxiliary script filter_log.sh and map.sh to extract the test results and from the log files and to build the result.csv file:


$ cat filter_log.sh


1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

grep -v bytes test_ping_v22*.log | grep -v rtt | grep -v statistics|grep packets

$ cat map.sh

#!/bin/ksh

while read line

do

server=`echo $line| cut -d '-' -f2`

dist=`echo $line| awk '{print $2}'`

RESULT=a

if [ $dist == "pingv22" ]

then

DATE=`echo $line| awk '{print $4 ";" $5}'`

fi

if [ $dist == "packets" ]

then

RESULT1=`echo $line| awk '{print $6}'`

RESULT=`echo $RESULT1| cut -d '%' -f1,1`

echo $server";"$DATE";"$RESULT

fi

done

Then the command executed to generate the result.csv file is:

1

$ filter_log.sh|map.sh > result.csv
To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Suseelan Hari

    Hi Luis,

    Good Day!

    Yes. You are correct. SAP Lumira is very good application which will help us to generation different types of charts, graphs and tables. I have also tried with different ideas and I enjoyed while generating new data sets every time. Different outputs using “host” , “date”, “time” and “packet_loss” and I feel this is different attempt. Keep it up.

    Have a nice day !

    Regards,

    Hari Suseelan

    (0) 

Leave a Reply