Skip to Content
Author's profile photo Gaurav Aggarwal

SAP Lumira – Data In, Information Out

Last month, I worked on an internal project where our objective was to be able to convert Big Data (25M records) into information quickly and in real time. We used SAP SD and Vistex IP (for Chargebacks, Incentives, Rebates and Royalties) module in SAP Business Suite on HANA box.  Using HANA Studio, we created a calculation view for Customer Profitability reporting and used SAP Lumira 1.2 for quick and efficient data conversion to information. What I like most in this newer version was story board. Now I would like to share my experience and visualizations that we created.

Connection: I used “Connect to SAP HANA” option which in other words is live connection which means that as soon as you make changes in the ECC system, those are seen in visualizations.


Once you are connected to system, you will all Analytical and Calculation views.


After selection the view we want to use, we can select Measure and Attributes from that view that we need for visualizations.


In the attribute section, we can filter values if needed.

In the Prepare tab, some options are greyed out when you use live HANA connection e.g. New Data Set, Combine as, New Calculated Attribute, Grid View.


Also If I remember correctly, in earlier version of Lumira there used to be an option for Time Hierarchy which I did not see this time.

Calculations: We can create a Calculated Measure based on our requirements.

Now, it is time to transform data into information. I prefer black background; therefore, changed my preferences as below:


Visualization 1


Visualization 2


Visualization 3


Visualization 4


The best thing with this release, I like is the story board (Compose). Using story board, I tried to find some answers.


For a Customer, OM was showing a decreasing pattern even though sales had increased as compared to Q1/Q2:


From the 2nd chart in story board, I got to know why:DG13.jpg

To boost the sales, More Rebates and Incentives were offered which brought in more sales but reduced the OM%.

I stuck to the basic charts as our primary objective was to report on big data and be able to tell a story simply and quickly, and Lumira did that for us 🙂 .

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member


      This is a great analysis! Really cool to see the real economic benefit of using SAP Lumira to understand financial information in a better way. You said you were using 1.12, have you upgraded to the latest and greatest Lumira release (SP 13) since then?

      Did you find that SAP Lumira was still running at top speed with 25mil records?



      Author's profile photo Gaurav Aggarwal
      Gaurav Aggarwal
      Blog Post Author

      Thanks for your words Anthony. I was happy to see the performance of Lumira with 25M records; visualizations were created/refreshed in no time. Only Table object took few seconds to refresh/filter but all other charts were fine.

      Yes, I have upgraded to SP13 but did not get time to work on it since then.



      Author's profile photo Former Member
      Former Member

      Hi Gaurav,

      Good Day!

      Very nice analysis! Keep up the good work!

      Keep sharing more information like this and motivate others too.

      Have a nice day! 🙂

      Keep Rocking!


      Hari Suseelan

      Author's profile photo Gaurav Aggarwal
      Gaurav Aggarwal
      Blog Post Author

      Thanks Hari.

      Author's profile photo Former Member
      Former Member

      Useful article.