I tried Lumira on one of our live HANA system. The HANA view that I am going to use in this blog is having 1,670,000,000+ General ledger records and data was replicated from SAP R/3 with help of SLT.

This view was created on top of BIG tables BSEG, BKPF, CSKS and others to provide comprehensive GL reporting with flexible filters or deep level aggregations. Example, results for G/L Account number, Cost Center, WBS Element, Company Code, Fiscal Year and Document Details.

1. Enable connection to SAP HANA

Select “SAP HANA One Online” as data source (We can also try offline with same steps).

Home.png

Enter server name, Instance number, credentials and click on ‘Connect SAP HANA Instance’.

HANA Login.png

We can see text in right side window once we have successful connection. Selected one of the view from right side window:

HANAConnect.png

2. HANA View data visualization:

As we can see in below screen shot, there are 73 attributes including ‘company code’, ‘gl account number’, ‘fiscal year’ etc., and 4 measures. (Best part is, it automatically identified measures and attributes from view).

Firstscreennodata.png

Click on ‘Visualize’ button to create visual reports.

/wp-content/uploads/2013/08/vis_271541.png

We can simply drag fields from view into below panel as per the requirement.

/wp-content/uploads/2013/08/pan_271543.png 

Below tool will help us to create various reports with different charts/options.

/wp-content/uploads/2013/08/tool_271545.png

Let’s try the first one…

As we can see in below screen shot, I have placed ‘Group Currency’ & ‘Quantity’ on Y-Axis and ‘Cost Center’ on X-Axis. We can do mouse over on results to see details about particular line/record.

Line.png

Filter option is available to show results for one or multiple cost centers (in above case). Note, the panel where we have Y-Axis and X-Axis may not be same for all as each chart will have it’s unique behavior.

For example, using Pie charts for combination of negative & positive values is theoretically not correct.  I got below results when I tried with my data.

/wp-content/uploads/2013/08/pie_271552.png

Sector with ‘Warning’ icon indicates that it’s negative amount. Also, if we look at below area charts and word charts, there is no traditional X-Axis and Y-Axis concept. This indicates, selecting and using right option for our business/client requirement can enrich the experience.

/wp-content/uploads/2013/08/tiles_271555.png

/wp-content/uploads/2013/08/bubbles_271562.png/wp-content/uploads/2013/08/words_271559.png

Above chart actually indicates that there is highest number of transaction amount in USD currency. Let’s place ‘Fiscal year’ instead of currency and filter data with ‘Fiscal Period’.

/wp-content/uploads/2013/08/filter1_271563.png

We can also exclude selected values by selecting “Exclude Values” radio button in “Filtered Values” sub window. You can see below results with corresponding title.

/wp-content/uploads/2013/08/filter2_271564.png

3. Response Time and Data Volume

I am happy user to say that there is no extra time to generate reports even though I am dealing with high volume of data. Of course, each time I change attribute or measure or chart type, it is taking around 30 secs that is to get data from HANA.

I received below error when I tried to display charts for ‘accounting document number’ vs ‘amount’..(FYI-There are more than million unique records). I totally agree with below message and I don’t think someone need report with more than that limit.

/wp-content/uploads/2013/08/tomuchdata_271574.png

4. Conclusion

This is powerful and quick visualization tool and we can create much… much better charts/reports with good understanding on business. No doubt, it has got all latest options by leaving things to our creative brains!

I like all these options! It took hardly 1hr time for me explore up to this this level! Prior to this GL data example, I tried Lumira with expensive movies list data for which word chart looks pretty cool. 😉

/wp-content/uploads/2013/08/movie_271560.png

Thank you!

Naveen Inuganti

To report this post you need to login first.

12 Comments

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

Leave a Reply