Using Lumira to Write ERP Data to HANA – No Modeling Required
I followed the steps Blog: SAP HANA SPS7 is now available in SAP HAN… | SAP HANA and set up my own HANA One instance on Amazon. Then I used Lumira 1.15 Desktop Freehand SQL to read an SAP ECC infoset, publish results to HANA and then use SAP BusinessObjects Analysis, edition for Microsoft Office to consume the HANA view.
Because there is no filtering available with Freehand SQL against an ECC InfoSet, everything comes back.
Below is the raw data of SAP Special Ledger data:
You can review the Share options below. Notice that Lumira Server is now offered but that is not GA yet so no publishing there. For more information on possible future use of Lumira see Future of Integrating SAP Lumira into Your Existing BI 4 Landscape SAP TechEd Online Notes Part 2
So this time I publish to SAP HANA (2nd button from the left above)
I am given the option to name the HANA package and view.
I can visualize the accounts by fund in Lumira, but this is not really for a formal visualization. The use case would be for an accountant to see that we have cash postings without a fund, and those need to be investigated.
Now I can use SAP BusinessObjects Analysis, edition for Microsoft Office to access the data that Lumira published to HANA:
I am using the HANA ODBC connection to Analysis Office.
So no HANA modeling was required; really no knowledge of SAP HANA and In-Memory Computing at all needed, other than please remember if you are using HANA AWS to stop your instance when not running and take images to save money.