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.
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:
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 🙂 .