(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)


General presentation

Objective of the application

The WBP BW QM application is created to follow

  • the Quality Results for 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

 


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 :

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


  • No labels