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

[TammyPowlas]

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":

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

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:

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

Just for fun I publish to the Lumira Cloud:

I can also save the document to the Lumira Cloud:

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

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

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

You can visualize on the iPad:

You can interact and analyze on the iPad as well.