Skip to Content

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

1pragmatiQa.jpg

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:

/wp-content/uploads/2014/11/2copyclipboard_591747.jpg

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

3importtoLumira.jpg

/wp-content/uploads/2014/11/4backtowrangling_591749.jpg

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

/wp-content/uploads/2014/11/5noconvertmonthyearoption_591750.jpg

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.

/wp-content/uploads/2014/11/6replace_591751.jpg

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?

/wp-content/uploads/2014/11/fi_591752.jpg

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:

/wp-content/uploads/2014/11/lob_591754.jpg

Here is the link of the story on Lumira Cloud

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply