You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

General presentation

Objective of the application

The WBP BW QM application is created to follow

  • the Quality Results for Shipment or 
  • 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/0BwfSNqWU_-PscU1Lb3NOSENRTmM


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

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Dependencies with other applications

Data loadings

Info providers and objects loaded

Loading frequency

Average performance

 

Key FigureEstimation
~ Average Process Chain Runtime 
~ 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 and workbook to integrate to for MiniCus and Minitab

Main functionalities

Broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution

 

  • No labels