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.

1sql.PNG

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:

2raw.PNG

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

3shareoptions.PNG

So this time I publish to SAP HANA (2nd button from the left above)

4publishtoHANA.PNG

I am given the option to name the HANA package and view.

6select.PNG

7visualize.PNG

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:

/wp-content/uploads/2014/02/8analysisoffice_383019.png

I am using the HANA ODBC connection to Analysis Office.

/wp-content/uploads/2014/02/9analysisoffice_383020.png

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.

You can hear more about Lumira at BI 2014 which is co-located with HANA 2014 next month in Orlando.

To report this post you need to login first.

1 Comment

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

Leave a Reply