Skip to Content
Author's profile photo Naveen Inuganti

HANA View data visualization from SAP Lumira

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

Assigned tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Nic Smith
      Nic Smith

      Great analysis for the DataGeek Challenge! Enter here: www.sap.com/datageek

      Author's profile photo Naveen Inuganti
      Naveen Inuganti
      Blog Post Author

      Thank you!

      Author's profile photo Former Member
      Former Member

      Nice analysis Naveen!

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Nice work... Informative. Regards, Krishna Chaitanya.

      Author's profile photo Former Member
      Former Member

      Good Analysis...

      Best Regards,

      Naresh K.

      Author's profile photo Former Member
      Former Member

      Awesome analysis! Great work ! 🙂

      Regards,

      Utkarsha

      Author's profile photo Naveen Inuganti
      Naveen Inuganti
      Blog Post Author

      Thank you all!

      Author's profile photo Ganesh S
      Ganesh S

      Good One

      Author's profile photo Former Member
      Former Member

      How were you able to gray out Freehand SQL, Universe 3.x and Universe 4.x?

      Author's profile photo Naveen Inuganti
      Naveen Inuganti
      Blog Post Author

      There was no additional step that I applied to disable them. But I think this 'default' status determined based on the data access drivers' availability.

      I can still open Freehand SQL and others with File->Preferences navigation from home screen of Lumira.

      Please refer section 4.5 from below document.

      http://help.sap.com/businessobject/product_guides/vi01/en/vi1_0_11_user_en.pdf

      Thanks,

      Naveen Inuganti

      Author's profile photo Former Member
      Former Member

      Hi Naveen,

      Good Day!

      Keep up the good work! I appreciate!

      Have a fruitful Day!

      Regards,

      Hari Suseelan

      Author's profile photo Former Member
      Former Member

      Good Analysis!!