Using XOData with SAP Lumira to Analyze Fiori Applications

A few weeks ago Ram Manohar Tiwari suggested using XOData – Visualize and Explore OData Services Online to analyze Fiori apps using https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/services/exparam.xsodata/$metadata

This is sort of the “agile BI” use case as I haven’t analyzed the meta data or looked at it in-depth.  I just want to access and report.

First, I saw the announcement “Latest XOData is now live. Also XOData Chrome App is free till end of 2014.”

So I downloaded the Chrome App and entered https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/services/exparam.xsodata/$metadata

Ideally it would be nice to use this as a datasource to Lumira but the closest connector I could find was OData v 2.0 and I don’t think this fits.

Some tips from Pragmati:

“CNTRL+A, CNTRL+C, would copy data to clipboard.”

So I try copy and paste to the clipboard and bring that into Lumira:

But that’s not enough data, so I export to CSV from the XOData – Visualize and Explore OData Services Online tool

I tried being lazy but there is not enough data to come up with any related visualizations.

There are some release dates in the file that are MM/YY but sadly Lumira doesn’t allow that type of date conversion (I will submit to Idea Place when I can)

So I am back to wrangling in Excel and then coming back into Lumira.

I want to analyze the number of applications at the top level so I replace the “-” with a comma and then “Split” in Lumira based on comma.

So what main SAP component has the most Fiori apps?

FI has the most apps, likely due to Simple Finance.

Finance also has the most line of business apps, but Supply Chain Management is a very close second:

Here is the link of the story on Lumira Cloud