Skip to Content
Author's profile photo Tammy Powlas

SAP Lumira: Getting Familiar Freehand SQL Against SAP ERP – then to iPad

John Mrozek does a great job of showing how you can connect to your SAP ERP system with Lumira in this blog SAP Lumira 1.0 SP11 – New features at a glance part 1

Note he says you cannot pass parameters in this version.  Therefore you need to ensure you are only returning small amounts of data against your ECC InfoSet.  I am using sample/test data from a custom SAP ERP Special Ledger Infoset.

One item I noticed is there is a button for “SQL History”:

/wp-content/uploads/2013/06/1sqlhistory_232015.png

The other thing I learned is you have to click the “Preview data” button before you can “Acquire” the data:

/wp-content/uploads/2013/06/2sqlpreview_232016.png

When using Freehand SQL against ECC you get the fields names – the Business Layer from the IDT provides more business-friendly terms,   As a result, I found myself renaming some of the fields and having to reformat, including converting to text:

/wp-content/uploads/2013/06/3aconverttotext_232017.png

At this point you can visualize the data in Lumira on the desktop:

4VISUALIZE.png

Just for fun I publish to the Lumira Cloud:

/wp-content/uploads/2013/06/5publishdataset_232019.png

I can also save the document to the Lumira Cloud:

/wp-content/uploads/2013/06/6savedocumenttolumiracloud_232020.png

See below from the Lumira Desktop – it shows the document has saved to the cloud:

/wp-content/uploads/2013/06/7lumiracloud_232021.png

After logging on to Lumira cloud (cloud.saplumira.com) you can see how it looks (still on the PC browser):

/wp-content/uploads/2013/06/8browserhowitlookswithdataset_232022.png

What is also nice is being able to visualize and interact with the data on the iPad:

9oniPad.PNG

You can visualize on the iPad:

10oniPad.PNG

You can interact and analyze on the iPad as well.

11interactonipad.PNG


Assigned tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Vijay Chanchlani
      Vijay Chanchlani

      Hi Tammy,

      Nice intuitive article.

      I was successfully able to connect the Lumira to SAP Backend using Java connector as you mentioned.

      However, I am not able to see any of my Backend tables in the list.

      I want to use the data stored in the SAP Backend tables.

      Regards,

      Vijay.

      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Hi Vijay,

      Supported ERP artifacts include SAP Queries and InfoSets (without parameters). Not tables.

      Regards

      Antoine

      Author's profile photo Vijay Chanchlani
      Vijay Chanchlani

      Thanks!
      So I created an infoset in ABAP Backend but joining my required backend tables and made a query on that. Works fine.

      Regards,

      Vijay.