2710 making the right decisions based on quality kpi

Making the Right Decisions Based on Quality KPIs

How SAP can support you in your analysis of Quality

Management data

Ingo Panchyrz, QM Product Management, SAP AG

ASUG Annual Conference 2013, Orlando FL, May 16 2013

Session Code: 2710

© 2012 SAP AG. All rights reserved. 2 Preliminary

Primary Goals

See the different ways of monitoring and

analyzing quality data with different QM tools

with SAP.

Experience the flexibility and full capabilities of

the QM Evaluation Cockpit for analyzing

inspection data and quality notifications.

Learn what would be the appropriate and most

beneficial tool for analyzing QM data in a

specific process to define important reports,

calculate required KPIs, and build quick and

easy-to-consume dashboards.

Quality Analytics Overview with focus on QM Cockpit for Evaluations


Agenda

Definition and Scope

Analytical Capabilities with…

…QM with ERP

…SAP NetWeaver BI

…Audit Management with SAP

…Quality Issue Management

QM Cockpit for Evaluations QGA4

Summary

Definition and Scope


Typical Questions in Terms of Analyzing QM Data

Which products are

blocked most

frequently and for

what reasons?

How can I get an

overview of my

quality-related

costs?

Which are our top 10

suppliers with regard to

product quality?

How many

complaints did

we receive from

customer XY?

Chief

Executive

Purchasing

Officer

Head of

Quality Assurance

Production

Operator

Sales

Manager

How did the critical

tolerance values for

our products evolve

over the last year?

Questions in order to make the right decision in time and quality


Different Approaches to Quality Management Analysis

Worklists

Pareto Analysis

Statistical Process Control

(SPC)

Supplier

evaluations

Results history

and trend analysis

Time-related

reports

Evaluation of

quality key figures

(list and graphical

display)

Certificates

for analysis &

inspection reports


…QM with ERP


Analytical Capabilities with QM with ERP

Ad-hoc reports & worklists

Worklists e.g. transaction QA33, QM11

Results history / trend analysis e.g. QGA1, QGA2



Process Control

Process Control via control charts (SPC)



Supplier evaluation

Supplier evaluation

Quality scores (goods receipts,

inspection lots)

Quality notifications (vendor-

related)

Audit results (inspection lots)



Key figures (KPIs) in Quality Information System (QMIS)

No. of notifications

No. of problems

No. of activities

No. of causes

No. of tasks

Lead time for notification

Sample size

Quality score

No. of completed samples

….

Accepted quantity

Rejected quantity

Returned quantity

Complaint quantity

Sum of defect valuations

No. of nonconformities

No. of nonconforming units

Fraction of nonconforming units

No. of lots

No. of rejections

…

Inspection Lots Notifications

Analyze QM data from notifications

and inspection lots

Predefined queries

Online and aggregated

Early warning system


…QM with NetWeaver BI


Analytical Capabilities with SAP NetWeaver BI

Solution at a glance

Business Explorer

Browser

Online Analytical

Processing System

(OLAP)

Online Transaction

Processing System

(OLTP)

InfoCubes

Source

Systems

Inspection

lots ERP

Extraction

Processing

Presentation

Workbooks /

Queries

BI

Notifications

& items



Flexible Reporting with the Query Designer and BEx Analyzer

BEx Query Designer or

Web Application Designer:

Define your own reports

using the stored data from BW

Use BEx Analyzer for

presentation (Excel) or publish

your report directly into the

Internet/intranet


Business content for

stability studies:

Inspection results

(general)

Inspection results

(quantitative)

Comparison of

characteristics

Trend analysis

Web reporting

Impurities C vs. F&G at 20°C

0,00

5,00

10,00

15,00

20,00

25,00

30,00

3.00 6.00 9.00 12.00 18.00 24.00

Time (months)

Perc

en

t

Impurity F+G (nach Ph. Eur)

Impurity C (nach Ph. Eur)


Example: Stability Study Reporting


… Audit Management with SAP


Analytical Capabilities with SAP Audit Management

Overview list, graphical representation

More display options, e.g. Excel in Place

Overview lists for

Audit plans

Audits

Actions

Question lists

Questions

Audit questions


Analytical Capabilities with SAP Audit Management

Example: Graphical analysis of assessment


Analysis of Audits via SAP NetWeaver BI

Extraction of operational data

Ready-Made Reports

• Overview of all audits

• Audit – Results Drill down to the audit question level

• Audits – State of completion Drill down to the action level

• Audit objects – Assessment

• Partners responsible – Audits & actions


…Quality Issue Management

© 2012 SAP AG. All rights reserved. 21

SAP Quality Issue Management (SAP QIM) Business Scenario & Purpose

SAP or non-SAP

systems

ERP

QIM

ERP

ERP

MES

ERP

Vendor

Issue Submitter / Issue

Driver / Activity Driver /

Activity Processor

CRM

GRC

Vendor

Customer

…

Issue

Reporter

Issue

Submitter

Issue

Driver

Activity

Driver

Activity

Processor

Observe &

address Issue

Capture

Issue

Add data, trigger

root-cause analysis

Define

activities

Process

activities

Issue

Driver

Validate results &

close issue

Modern and flexible approach for

capturing and processing any kind of

issue and its related activities, e.g. 8D,

CAPA

Allows easy tracking and analyzing

issues and activities beyond

applications and systems

Can integrate with processes in other

applications by triggering issues in QIM

or initiating follow-up actions in the

related applications

Control / evaluate


SAP QIM – A Comprehensive Approach Monitoring, Coordinating, and Analyzing Issues and Activities

Across different sources

and applications, e.g. ERP

notifications and items, audit

actions, FMEA defects

Flexibility in defining

relevant queries

Monitoring control

via traffic light


Analysis of Issues Across Sources

Evaluate issues via Business Context Viewer [BCV]

Context-related analytics

and dashboards

Across different sources and applications

QM Evaluation Cockpit


Offline Demo

Demo


QM Evaluation Cockpit QGA4

Flexible Reporting Capabilities within SAP ERP (online)

The QM Cockpit for Evaluations allows you to …

• Create analytical reports on quality data combined with meaningful

graphical representation

• For inspection lots, characteristics, and results

• For defects

• For notifications

• For components from production chain

• Flexibly select the data to be analyzed

• Evaluate online and archived data

• Compare results for several characteristics, graphically or via table

views

• Determine and display key figures

• Create control charts without detailed planning

• Influence the layout (table or graphic) and key figures…..



Structure of the Application

Tree with determined data on the

left-hand side (inspection lots,

characteristics etc.).

Graphical

representation

Table view

Representation of

external results

Detail view



Selection of Object Type

New - selection of an object type within the transaction:

Inspection lots, notifications, or components

After that, start the selection via the “Selection” button

An additional selection of data element is required related to the

chosen object type



Selection Screens

The selection screens depend

on the chosen object type

Inspection lots

Notifications

Components



Data Selection

If you start a new

selection with the

given layout, the

content will be

updated, not replaced

This reduces

performance

bottlenecks!



Selection of Table Views

Within the list of

determined data, you can

select a specific table

view to represent the

data.

SAP already provides

some standard views as

shown.

All views must be defined

in Customizing.



Selection of Graphics

Within the list of

determined data, you

can select a specific

graphic to represent the

data.

SAP already provides

some standard graphics

as shown.

All views must be defined

in Customizing.



Comparison of Characteristics


Comparison of Characteristics


Evaluation of Notifications


Evaluation of Notifications



Pareto Chart of Defects

For the display of defect frequencies, the graphic type pareto chart is available. In

addition, more key figures are available.



Evaluation of Components 1

First decide whether your selection should

include inspection lots or notifications.

You can also update a selection with lots or

notifications.

For the selection material,

plant and batch must be

given.

Other selection criteria are

optional.



Evaluation of Components 2

Evaluation of components can include

Inspection data

Notification

Defect data



Available KPIs via QM Evaluation Cockpit

Further, customer-specific ones can be

defined via data structure: QGEVAL_INSPECTION_LOTS_KPI

Calculation rule to be defined via BAdI: QG_EVAL_MANAGER

Process Capability Index (cp, cpk) Number of Measured Values Below the Tolerance Range

Standard Deviation of Valid Measured Values Standard Deviation from Overall Dispersion

Arithmetic Mean of Valid Measured Values Percentage of Skips

Number of Inspected Sample Units Percentage of Characteristics with CpK > 1.33

Maximum Value of the Valid Measured Values Percentage of Characteristics with CpK > 1.67

Minimum Value of the Valid Measured Values Percentage Within Specification

Number of Measured Values Above the Tolerance Range Quality Score

SAP offers a list of standard KPIs


Enhancements Within QGA4 in Context of Customer

Connection Program

Characteristics

Grouping characteristics are now

highlighted

Option to show original selection that

was used to create a table or graphical

representation

New function to clear all screens in one

go

New Implementation Type available in

order to display detail views. Example

is provided to display notification data

per quality notification (can also be

used as template for additional

customer-specific screens)

Activation via Customizing switch


Improvements Within QGA4

Define Layout - Grouping Characteristics

Grouping characteristics can be identified

by prefix “ * ” within layout definition



Grouping Characteristics Within Tree

Grouping characteristic columns can also

be identified by prefix “*” and corresponding

tooltip within the tree.

Other key figures and columns do not have

the prefix “*”.



Select Data Nodes Used – Show Original Selection

New button:

Select Data Nodes Used



Select Data Nodes Used – Show Original Selection

• Relevant objects are marked in the tree

• If required, nodes are expanded automatically

• “Focus” topic changes automatically (Inspection Lots,

Quality Notifications etc.)



Detail View Within QGA4

Enhanced menu

New implementation type (450)

provided in order to show important

notification header data



Detail View Within QGA4

Detail views are displayed on the right-hand side. One screen

section is filled for each entry of the aggregated form.

Other screens can be accessed

via page down / page up buttons



Detail View Within QGA4 - Toolbar

With the Detail button the user can directly

navigate to display or edit mode for the notification

Implementation Info

Close View

The quality notification can be called

directly in display or change mode



Detail Views Within QGA4

The “Close Views” button clears all subscreens in one go.

Applies to tables, graphics, and detail and external views.

Outlook

QM Analytics: Roadmap and UI Examples


Legal Disclaimer

This presentation outlines our general product direction and should not be

relied on in making a purchase decision. This presentation is not subject to

your license agreement or any other agreement with SAP. SAP has no

obligation to pursue any course of business outlined in this presentation or

to develop or release any functionality mentioned in this presentation. This

presentation and SAP's strategy and possible future developments are

subject to change and may be changed by SAP at any time for any reason

without notice. This document is provided without a warranty of any kind,

either express or implied, including but not limited to, the implied warranties

of merchantability, fitness for a particular purpose, or non-infringement. SAP

assumes no responsibility for errors or omissions in this document, except if

such damages were caused by SAP intentionally or grossly negligent.


Outlook QM Analytics: Roadmap and UI Examples

Context-Related Information via Side Panel Approach

NetWeaver Business Client [NWBC] required

Side Panels

- Highly configurable

- Customer/partner content

- Embedded analysis/reports

and 3D-viewer

- Integrated social media

capabilities to support

collaboration within and

across enterprises


Outlook QM Analytics: Quality Management on HANA

Focus Areas

Focus Areas

Porting • Logical database PGQ and

transactions / reports used in QM

Analytics • Deliver different KPIs on QM data

and across (e.g. ppm)

Search on HANA • Search for inspection lots,

notifications & master data

• Fact Sheets

Summary


7 Key Points to Take Home SAP Analytics for Quality Management Support Different Aspects

Supports quality control mechanism &

continuous improvement steps

Provides KPIs as basis for

management decisions

Supports work processes via worklists

Notifies about severe issues

Provides quick overview on current

quality status

Different means of presentation –

graphics and tables

Flexibility in terms of offering different

tools on different platforms

1

2

3

4

5

6

7


Interesting Links

https://service.sap.com/qm

Media Library (requires login credentials)

General Brochures on QM and Audit Management

SAP Service Marketplace

www.sapimprovementfinder.com (requires login credentials)

Improvement Finder (Enhancements in QGA4)

OSS-Note 1335171 “FAQ: QM Evaluation Cockpit QGA4“ via SAP Service Marketplace

service.sap.com (requires login credentials)

http://www.sapimprovementfinder.com/

http://www.sapimprovementfinder.com/

Questions?

Session Code: 2710

Thank You! Contact Information:

Ingo Panchyrz

Product Expert

Product Management Quality Management

SAP AG

Dietmar-Hopp-Allee 16

69190 Walldorf, Germany

M +49/160-8896680

F +49/6227/78-39222

mailto: [email protected]

http://www.sap.com

mailto:[email protected]

http://www.sap.com/

2710 making the right decisions based on quality kpi

Documents

quality data

qm data

quality kpis

product quality

qm product management

qm evaluation cockpit

qualityrelated costs

quality analytics overview