My Report (DRAFT)

Process Owner

Diane Kealy
Process Expert, Provisioning

D&PS Expert

Marie-Line Ardito

List of KPIs available in other sheets:

KPI	Availability
%Payment On Time	Top Highlight Box Process Effectiveness Scorecard
#Payment	Process Effectiveness
#Payment on Time	Process Effectiveness

%Late Posting Volume	Process Effectiveness Top Highlight Box
Late Posting Volume	Process Effectiveness
Invoices Posted	Process Effectiveness

%Buying Channel Compliance (Volume)	Top Highlight Box Process Conformity Scorecard
PO Item Amount	Process Conformity
PO Item Volume	Process Conformity
%Compliance Amount	Process Conformity

%Invoices Amount	Process Conformity
Invoices Amount	Process Conformity
%Invoices Volume	Process Conformity
Invoices Volume	Process Conformity

%Documents Received Overdue	Top Highlight Box Process Conformity Scorecard
Late Invoices	Process Conformity

%Non Conform Preq	Top Highlight Box Process Conformity Scorecard

%Paperless Invoices	Scorecard

%WC	Scorecard

List of KPIs exclusive from "My Table":

Delivery On time

KPI	Calculation:	Other informations:	BW query:
%Delivery On Time	On time = In advance + On Time + D+1	Date Reference: PO Good Receipt date Weekends are counted as days for DOT Target:* 80% for goods being received on time. Refresh period for M-1: 1st & 5th & 26th	Core Query: BW_QRY_MV_PROVG_0004 QV Query: QVSBS_BW_QRY_MV_PROVG_0003
%Delivery Delivery Time Class = In Advance	Good Receipt date < Schedule line delivery date
%Delivery On Time Delivery Time Class = On Time	Good Receipt date = Schedule line delivery date
%Delivery Delivery Time Class = D+1	Good Receipt date = Schedule line delivery date +1
%Delivery Delivery Time Class > D+1	Good Receipt date > Schedule line delivery date +1

Automatic Posting

KPI	Other Informations	BW query
Automatic posting	Date Reference: PO Creation date Refresh period for M-1:	Core Query: BW_QRY_MV_PROVG_0006 QV Query: QVSBS_BW_QRY_MV_PROVG_0005
%Automatic Posting
Number of PO

Paperless Invoices


Paperless Invoices	Date Reference: Posting Date Target: >50% Refresh frequency: 1st, 5th and 26th of each month	Core Query: BW_QRY_MV_APRS1_0003 QV Query: QVSBS_BW_QRY_MV_APRS1_0003B
Invoices Posted
%Paperless Invoices

Web Cycle


Docs Posted w/o WC		Date Reference: Posting Date Refresh frequency: Monthly - 1st, 5th and 26th of each month	Invoices Posted Core Query: BW_QRY_MV_APRS1_0003 QV Query: QVSBS_BW_QRY_MV_APRS1_0003B WC Core Query: BW_QRY_MV_RDSF01_0001 QV Query: QVSBS_BW_QRY_MV_RDSF01_0001C
%WC

Page tree

My Report (DRAFT)

Diane Kealy Process Expert, Provisioning

Marie-Line Ardito

Availability

List of KPIs exclusive from "My Table":

Delivery On time

%Delivery On Time

On time = In advance + On Time + D+1

Date Reference: PO Good Receipt date *Weekends are counted as days for DOT

Target: 80% for goods being received on time.

Refresh period for M-1: 1st & 5th & 26th

Core Query:BW_QRY_MV_PROVG_0004

QV Query:QVSBS_BW_QRY_MV_PROVG_0003

%Delivery Delivery Time Class = In Advance

%Delivery On TimeDelivery Time Class = On Time

Good Receipt date = Schedule line delivery date

%Delivery Delivery Time Class = D+1

Good Receipt date = Schedule line delivery date +1

%Delivery Delivery Time Class > D+1

Good Receipt date > Schedule line delivery date +1

Automatic posting

Date Reference: PO Creation date

Refresh period for M-1:

Core Query:BW_QRY_MV_PROVG_0006QV Query:QVSBS_BW_QRY_MV_PROVG_0005

%Automatic Posting

Number of PO

Paperless Invoices

Paperless Invoices

Date Reference: Posting Date Target: >50%

Refresh frequency: 1st, 5th and 26th of each month

Core Query:BW_QRY_MV_APRS1_0003QV Query:QVSBS_BW_QRY_MV_APRS1_0003B

Invoices Posted

%Paperless Invoices

Web Cycle

Docs Posted w/o WC

Date Reference:

Posting Date

Refresh frequency:

Monthly - 1st, 5th and 26th of each month

Invoices PostedCore Query: BW_QRY_MV_APRS1_0003 QV Query: QVSBS_BW_QRY_MV_APRS1_0003BWCCore Query: BW_QRY_MV_RDSF01_0001QV Query: QVSBS_BW_QRY_MV_RDSF01_0001C

%WC

Diane Kealy
Process Expert, Provisioning

Date Reference:
PO Good Receipt date
*Weekends are counted as days for DOT

Target:
80% for goods being received on time.

Refresh period for M-1:
1st & 5th & 26th

Core Query:
BW_QRY_MV_PROVG_0004

QV Query:
QVSBS_BW_QRY_MV_PROVG_0003

%Delivery
Delivery Time Class = In Advance

%Delivery On Time
Delivery Time Class = On Time

%Delivery
Delivery Time Class = D+1

%Delivery
Delivery Time Class > D+1

Date Reference:
PO Creation date

Core Query:
BW_QRY_MV_PROVG_0006
QV Query:
QVSBS_BW_QRY_MV_PROVG_0005

Date Reference:
Posting Date

Target:
>50%

Refresh frequency:
1st, 5th and 26th of each month

Core Query:
BW_QRY_MV_APRS1_0003
QV Query:
QVSBS_BW_QRY_MV_APRS1_0003B

Invoices Posted
Core Query: BW_QRY_MV_APRS1_0003
QV Query: QVSBS_BW_QRY_MV_APRS1_0003B

WC
Core Query: BW_QRY_MV_RDSF01_0001
QV Query: QVSBS_BW_QRY_MV_RDSF01_0001C