Efficient Plant March 2020 - 20

enterprise software tips

Display Real-Time KPI Data
Use easily managed S/4HANA queries
to generate KPI dashboards.
Kristina Gordon, Illumiti

When building a Query, the right-hand side provides dimensions to define
your KPI. Just like using a pivot table, simply click and drag the dimensions to the columns and rows to create your KPI tile.

In the past, pulling data for KPIs (key performance indicators) and
metrics in SAP could present some challenges. In SAP S/4HANA,
queries exist that, in real time, can display best-practice KPIs. A
dashboard can easily be built to display the results.

The maintenance metrics are a combination of queries that can be built
by a user or consultant and rolled out to all users, along with some
standard Fiori tiles. There are four standard maintenance queries:
 Maintenance Object Breakdown (Mean Time between Failure)
 Damage Analysis (Bad Actors)
 Maintenance Order Analysis Query
 Location and Notification Analysis
 Actual Cost (planned work vs. unplanned work).
There are also some standard out-of-the box materials-management
tiles that can be used primarily for MRO materials, i.e., tracking KPIs for
maintenance-material cost:
 Overview Inventory Management
 Monitor Material Coverage

There are buttons on the tool bar that allow you to change your KPI to just
a chart or graph view, or a combination of chart or graph with detailed
data below the picture. You can export your KPI, email it to another person
from the KPI screen, or click the button on the end (highlighted with a red
circle) to enlarge the screen and make the report builder on the side stay
hidden.

Below is an example of the maintenance object breakdown query:
This KPI feature allows companies to now spend 10% of their time gathering data and 90% analyzing it, thus the ability to make critical decisions
that will increase plant reliability. EP

Kristina Gordon is SAP Principal Consultant at Illumiti, Thornhill,
Ontario (illumiti.com). If you have SAP questions, send them to editors@
efficientplantmag.com and we'll forward them to Kristina.

20

EP2003rmcsap.indd 20

| EFFICIENTPLANTMAG.COM

MARCH 2020

2/17/20 11:52 AM


http://www.illumiti.com http://www.cientplantmag.com http://www.EFFICIENTPLANTMAG.COM

Efficient Plant March 2020

Table of Contents for the Digital Edition of Efficient Plant March 2020

Efficient Plant March 2020 - 1
Efficient Plant March 2020 - Cover1
Efficient Plant March 2020 - Cover2
Efficient Plant March 2020 - 1
Efficient Plant March 2020 - 2
Efficient Plant March 2020 - 3
Efficient Plant March 2020 - 4
Efficient Plant March 2020 - 5
Efficient Plant March 2020 - 6
Efficient Plant March 2020 - 7
Efficient Plant March 2020 - 8
Efficient Plant March 2020 - 9
Efficient Plant March 2020 - 10
Efficient Plant March 2020 - 11
Efficient Plant March 2020 - 12
Efficient Plant March 2020 - 13
Efficient Plant March 2020 - 14
Efficient Plant March 2020 - 15
Efficient Plant March 2020 - 16
Efficient Plant March 2020 - 17
Efficient Plant March 2020 - 18
Efficient Plant March 2020 - 19
Efficient Plant March 2020 - 20
Efficient Plant March 2020 - 21
Efficient Plant March 2020 - 22
Efficient Plant March 2020 - 23
Efficient Plant March 2020 - 24
Efficient Plant March 2020 - 25
Efficient Plant March 2020 - 26
Efficient Plant March 2020 - 27
Efficient Plant March 2020 - 28
Efficient Plant March 2020 - 29
Efficient Plant March 2020 - 30
Efficient Plant March 2020 - 31
Efficient Plant March 2020 - 32
Efficient Plant March 2020 - Cover3
Efficient Plant March 2020 - Cover4
https://www.nxtbook.com/atp/MaintenanceTechnology/efficient-plant-june-2021
https://www.nxtbook.com/atp/MaintenanceTechnology/epapril2021
https://www.nxtbook.com/atp/MaintenanceTechnology/epmarch2021
https://www.nxtbook.com/atp/MaintenanceTechnology/epjanfeb2021
https://www.nxtbook.com/atp/MaintenanceTechnology/epjulyaug2020
https://www.nxtbook.com/atp/MaintenanceTechnology/epjune2020
https://www.nxtbook.com/atp/MaintenanceTechnology/epmay2020
https://www.nxtbook.com/atp/MaintenanceTechnology/epapril2020
https://www.nxtbook.com/atp/MaintenanceTechnology/epmarch2020
https://www.nxtbook.com/atp/MaintenanceTechnology/epfeb2020
https://www.nxtbook.com/atp/MaintenanceTechnology/epjan2019
https://www.nxtbook.com/atp/MaintenanceTechnology/epnovdec2019
https://www.nxtbook.com/atp/MaintenanceTechnology/epseptoct2019
https://www.nxtbook.com/atp/MaintenanceTechnology/epmay2019
https://www.nxtbook.com/atp/MaintenanceTechnology/epapril2019
https://www.nxtbook.com/atp/MaintenanceTechnology/epmarch2019
https://www.nxtbook.com/atp/MaintenanceTechnology/epfebruary2019
https://www.nxtbook.com/atp/MaintenanceTechnology/epjanuary2019
https://www.nxtbook.com/atp/MaintenanceTechnology/epdecember2018
https://www.nxtbook.com/atp/MaintenanceTechnology/epnovember2018
https://www.nxtbook.com/atp/MaintenanceTechnology/epoctober2018
https://www.nxtbook.com/atp/MaintenanceTechnology/epseptember2019
https://www.nxtbook.com/atp/MaintenanceTechnology/epaugust2018
https://www.nxtbook.com/atp/MaintenanceTechnology/0818schneider
https://www.nxtbook.com/atp/MaintenanceTechnology/epjuly2018
https://www.nxtbook.com/atp/MaintenanceTechnology/epjune2018
https://www.nxtbook.com/atp/MaintenanceTechnology/epmay2018
https://www.nxtbook.com/atp/MaintenanceTechnology/epapril2018
https://www.nxtbook.com/atp/MaintenanceTechnology/epmarch2018
https://www.nxtbook.com/atp/MaintenanceTechnology/epfebruary2018
https://www.nxtbook.com/atp/MaintenanceTechnology/epjanuary2018
https://www.nxtbook.com/atp/MaintenanceTechnology/epdecember2017
https://www.nxtbook.com/atp/MaintenanceTechnology/epnovember2017
https://www.nxtbook.com/atp/MaintenanceTechnology/epoctober2017
https://www.nxtbook.com/atp/MaintenanceTechnology/mtsept2017
https://www.nxtbook.com/atp/MaintenanceTechnology/mtaugust2017
https://www.nxtbook.com/atp/MaintenanceTechnology/mtjuly2017
https://www.nxtbook.com/atp/MaintenanceTechnology/mtjune2017
https://www.nxtbook.com/atp/MaintenanceTechnology/mtmay2017
https://www.nxtbook.com/atp/MaintenanceTechnology/mtapril2017
https://www.nxtbook.com/atp/MaintenanceTechnology/mtmarch2017
https://www.nxtbook.com/atp/MaintenanceTechnology/mtfebruary2017
https://www.nxtbook.com/atp/MaintenanceTechnology/mtjanuary2017
https://www.nxtbook.com/atp/MaintenanceTechnology/mtdecember2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtnovember2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtoctober2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtseptember2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtaugust2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtjuly2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtjune2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtmay2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtapril2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtmarch2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtfebruary2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtjanuary2016
https://www.nxtbook.com/atp/MaintenanceTechnology/mtdecember2015
https://www.nxtbook.com/atp/MaintenanceTechnology/mtnovember2015
https://www.nxtbook.com/atp/MaintenanceTechnology/mtoctober2015
https://www.nxtbook.com/atp/MaintenanceTechnology/mtseptember2015
https://www.nxtbook.com/atp/MaintenanceTechnology/MTAugust2015
https://www.nxtbook.com/atp/MaintenanceTechnology/MTJuly2015
https://www.nxtbook.com/atp/MaintenanceTechnology/MTJune2015
https://www.nxtbook.com/atp/MaintenanceTechnology/M
https://www.nxtbook.com/atp/MaintenanceTechnology/0415endress
https://www.nxtbook.com/atp/MaintenanceTechnology/MTApril2015
https://www.nxtbook.com/atp/MaintenanceTechnology/MTMarch2015
https://www.nxtbook.com/atp/MaintenanceTechnology/MTFebruary2015
https://www.nxtbook.com/atp/MaintenanceTechnology/MTJanuary2015
https://www.nxtbook.com/atp/MaintenanceTechnology/MTDecember2014
https://www.nxtbook.com/atp/MaintenanceTechnology/MTNovember2014
https://www.nxtbook.com/atp/MaintenanceTechnology/MTOctober2014
https://www.nxtbook.com/atp/MaintenanceTechnology/MTSeptember2014
https://www.nxtbook.com/atp/MaintenanceTechnology/MTAugust2014
https://www.nxtbook.com/atp/MaintenanceTechnology/MTJuly2014
https://www.nxtbookmedia.com