Versions Compared

Old Version 5

changes.mady.by.user THEVENET, Guillaume

Saved on

compared with

New Version Current

changes.mady.by.user AVIDI-ext, Jayasri

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

(warning)     (warning)     (warning)     (warning)

The new wiki link for this data flow is here:

Technical Documenation - Quality Management Report

Please update the doc there and no longer here.

(warning)    (warning)       (warning)       (warning)


Table of Contents

General presentation

Objective of the application

The WBP BW QM application is created to follow

  • the Quality Results for Shipment or Shipment 
  • As source of MiniCus or MniTab application 
  • To follow the Limites, Quantitative and qualitative results of the Quality inspections.
  • Statistical ratios and calculations on the quality inspections results

...


Usage information

Data from Statistics :

By Infoproviders :

...


Calendar Year/MonthJAN 2016FEB 2016MAR 2016APR 2016MAY 2016JUN 2016Overall Result
InfoProviders Used
 

Query Access CounterQuery Access CounterQuery Access CounterQuery Access CounterQuery Access CounterQuery Access CounterQuery Access Counter
Overall Result
 

336
459
301
574
571
708
444
601
296
436
424
510
2 372
3 288
ODSO/A/ODS_QM09Inspection Results:2902384634052563652 017
MPRO/A/MVGSVQM
WBP_400/
MPRO/A/
MVGSVQM6018868847646522MPRO/A/
MPR_
QMMPR_QM353541353537218MPRO/A/MPR_
QM001WBP_400/MPRO/A/MPR_QM001332267262525198
MPRO/A/MPR_GSVQM
GSV - QM Notificatio28502838293176
ODSO/A/ODS_QM08Inspection Results:11251565365
ODSO/A/ODS_QM02Notification - Task
 

27241328
ODSO/A/ODS_QM06Notification
 

2624923
ODSO/A/DSO_QM10QM Preparation Trans15921119
ODSO/A/DSO_QM11QM Preparation Trans1311129
ODSO/A/ODS_QM05Notification - Item
 

020057
ISET/A/IFS_QMTRQM x TR
 

41
 

016

 

By Queries :

...


Calendar Year/MonthJAN 2016FEB 2016MAR 2016APR 2016MAY 2016JUN 2016Overall Result
Query
 

Query Access CounterQuery Access CounterQuery Access CounterQuery Access CounterQuery Access CounterQuery Access CounterQuery Access Counter
Overall Result
 

336
459
301
574
571
708
444
601
296
4365103 288
4242 372
ELEM/A/BW_QRY_ODS_QM09_0005BW - QM Results - Column (Core Query)1861453502861652621 394
ELEM/A/BW_QRY_MVGSVQM_0003SPRINT - PUR: Non Conformance Analysis (Core Query)5418464807142495
ELEM/A/BW_QRY_ODS_QM09_9000QM - Inspection Results by Lot585887856752407
ELEM/A/BW_QRY
_MPR
_
GSVQM_0003GSV - QM Notification Vendor Analysis28362838283161ELEM/A/BW_QRY_
ODS_QM09_0004BW - QM Results (Core Query)282123281842160
ELEM/A/BW_QRY_MPR_QM001_QVRCSKPI_0000RCS QM KPI - Quality Results for Shipment (Core Query)252033212222143
ELEM/A/BW_QRY_MPR_
QM_QVRCSKPI_0000RCS QM KPI - Raw Data for Qlikview (Core Query)202224222224134ELEM/A/BW_QRY_MPR_
QM001_0001BW - Quality Results for Deliveries (Core Query)823453355
ELEM/A/BW_QRY_ODS_QM09_0002BW - QM Statistics (Core Query)1613054846
ELEM/A/BW_QRY
_MPR_QM
_
0001RCS QM KPI - Synthesis (Core)97877745ELEM/A/BW_QRY_
ODS_QM02_9001BW Brazil - QM - Notification - Tasks
 

272412
27ELEM/A/QVPPV_BW_QRY_MVGSVQM_0003SPRINT - PUR: Non Conformance Analysis (Core Query) - QV
644454
27
ELEM/A/BW_QRY_ODS_QM08_9003QM - Laboratory Billing (by Determinations)413411124
ELEM/A/BW_QRY_ODS_QM06_9000BW Brazil - QM - Notifications
 

2624923
ELEM/A/BW_QRY_ODS_QM08_9004QM - Laboratory Productivity (by Workcenter)49331121
ELEM/A/BW_QRY_ODS_QM08_9005QM - Laboratory Productivity (by Analyst)33823120
ELEM/A/BW_QRY_DSO_QM10_9001BW - QM Laboratory's Productivity (Solution's Factorization)15921119
ELEM/A/BW_QRY_MPR_GSVQM_0002
GSV QM - Notice 14    14
ELEM/A/BW_QRY_ODS_QM09_0001BW - Analytical time (Core Query)1131219
ELEM/A/BW_QRY_DSO_QM11_9001BW - QM Laboratory's Productivity (Solution's Preparation)1311129
ELEM/A/BW_QRY
_MPR_QM
_
0004RCS QM KPI - Cancelled Lots (Core)1131118ELEM/A/BW_QRY_MPR_QM_0003RCS QM KPI - Lots Waiting for UD (Core)1121117ELEM/A/BW_QRY_
IFS_QMTR_0001BW - Quality Results for Shipment (Core Query)
 

41
 

016
ELEM/A/BW_QRY
_MPR_QM
_
0002RCS QM KPI - Automatically Created 89 Lot (Core)1111116ELEM/A/BW_QRY_MPR_QM_0005RCS QM KPI - Average Delay for UD (Core)1111116ELEM/A/BW_QRY_MPR_QM_0006RCS QM KPI - Lot with Incorrect Valuation (Core)1111116ELEM/A/BW_QRY_MPR_QM_0007RCS QM KPI - Lot Long Term with No UD (Core)1111116ELEM/A/BW_QRY_
ODS_QM05_9000BW Brazil - QM - Notification - Item
 

000044
ELEM/A/BW_QRY_ODS_QM05_0002BW - QM Notification Items (Core Query)
 
 


2
  


13
ELEM/A/BW_QRY_ODS_QM09_0003BW - QM Lead Time (Core Query)1
 
 


0
  


1
ELEM/A/BW_QRY_ODS_QM02_0001BW - QM Notification Tasks (Core Query)
  


00
 11ELEM/A/BW_QRY_MPR_GSVQM_0003_BCAST_01GSV - QM Notification Vendor Analysis (Broadcast)    

1
 
1
ELEM/A/RCS_QRY_ODS_QM09_0007BW - QM Results for maintenance PM (Core Query)
    




000

 


History

Roles & Access

Roles and access

List of application role + menu role  and explanation if we have several applications role with specials rules.

Role CodeRole DescriptionExplanation
       
  









Authorization objects

List of autorisation objects mandatory for the application.

Authorization objectExplanation
      






Dataflow overview & Documentation

Link below for documentation

https://drive.google.com/drive/folders/

...

1NfOEBZU5HxSoUSLvH0RuujZDZF97pCR8

 

Direct link for Dataflow :

Embedded Google Drive File
docid16AOPtzKtDc2UjZGM36m2zW5KRAuBkDiBaMA92YEUKSk
width950px

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Dependencies with other applications

Data loadings

Info providers and objects loaded

PC_QM_00 (META - D - QM - Master Chain)

Sub chain detail

Loading frequency

Once a day. Estimate,  start loading around 3:30 and finish 4:20 AM CET with delta loading. it is triggered by RSP_DAILY on 0:01 flow after P&L, Tier and SD.  

Average performance

...


Key FigureEstimation
~ Average Process Chain Runtime
 
 50 minutes
~ Average nb of rows loaded per load
 

~ Total nb of rows loaded (if full)
 

~ Average Runtime for 10k lines
 

Record Keeping

Reporting

Queries End User Documentation

 


Main queries

It is one query based on MPR_QM001 multiprovider and workbook to integrate to for MiniCus and Minitab

Main functionalities

Broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution

 To decommission old data flow (MVQM01, MVQM02, ODS_QM08 and ODS_QM09) and migrate QM queries