Page 1 of 1

Running A Metrics Display Board

Posted: Thu May 30, 2019 11:16 am
by givol
I'm a new summer intern for a local company and I have been assigned to make a Metrics board. Basically, I will need to automatically pull data from a SAP and calculate individual peoples "efficiency" by taking the Planned Hours and comparing it to the Actual Labor hours. If the Planned is higher than actual their efficiency would be less than 100% and I want to display that value and change the next color to relate to how inefficient they are if possible. Lastly, every day at say 5:00am I need to restart or pull fresh data from the SAP to display a list of the parts that need to be made that day. I am willing to learn how to do all of this, I just need to be pointed in the right direction or learn if talking to a SAP is even possible to do with a Pi.

Re: Running A Metrics Display Board

Posted: Sun Jun 02, 2019 5:18 am
by omegaman477
So as you rightly said, getting access to the SAP data is your biggest challenge.

If the data you need is in SAP BW, and they have a API enabled for that cube, your good. This is a basic restful API over HTTP. Easy to do on a RPI and with Python.

If the data is not in a BW cube, then it gets harder. Most likely a ABAP job will need to be written that exports the data via flat file to a file system or FTP server. I would expect the System Admin team (or BASIS) team will be able to do this, once the flat file is exported, you can use whatever tools you like to retrieve the file and load it into Python.

What module in SAP are you calling the data from (AP, LookingGlass, HR/PY, PM?)