Versions Compared

Old Version 9

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
 

3363015714442964242 372
ODSO/A/ODS_QM09Inspection Results:2902384634052563652 017
MPRO/A/MPR_QM001WBP_400/MPRO/A/MPR_QM001332267262525198
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
 

3363015714442964242 372
ELEM/A/BW_QRY_ODS_QM09_0005BW - QM Results - Column (Core Query)1861453502861652621 394
ELEM/A/BW_QRY_ODS_QM09_9000QM - Inspection Results by Lot585887856752407
ELEM/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_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_ODS_QM02_9001BW Brazil - QM - Notification - Tasks
 

27241227
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_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_IFS_QMTR_0001BW - Quality Results for Shipment (Core Query)
 

41
 

016
ELEM/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
 

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




000
0

 


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/0BwfSNqWU_-PscU1Lb3NOSENRTmM1NfOEBZU5HxSoUSLvH0RuujZDZF97pCR8

 

Direct link for Dataflow :
https://docs.google.com/presentation/d/1BEtcW74HlAltYo9FWxzcxFPDcIIrIcAr_Xx01JJ2vsI/edit#slide=id.p

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

Average performance

...

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_QM03 multiprovider 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