Skip to Content

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.

DG1.jpg

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

DG2.jpg

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

DG3.jpg

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.

DG4.jpg

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.

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

DG6.jpg

Visualization 1

DG7.jpg

Visualization 2

DG8.jpg

Visualization 3

DG9.jpg

Visualization 4

DG10.jpg

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

DG11.jpg

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

DG12.jpg

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

To report this post you need to login first.

5 Comments

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

  1. Anthony Gandouin

    Gaurav,

    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?

    Cheers,

    Anthony

    (0) 
    1. Gaurav Aggarwal 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.

      Regards,

      Gaurav

      (0) 
  2. Suseelan Hari

    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!

    Regards,

    Hari Suseelan

    (0) 

Leave a Reply