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

Compare with Current View Page History

« Previous Version 5 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 4595747086014365103 288
ODSO/A/ODS_QM09Inspection Results:2902384634052563652 017
MPRO/A/MVGSVQMWBP_400/MPRO/A/MVGSVQM6018868847646522
MPRO/A/MPR_QMMPR_QM353541353537218
MPRO/A/MPR_QM001WBP_400/MPRO/A/MPR_QM001332267262525198
MPRO/A/MPR_GSVQMGSV - 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 4595747086014365103 288
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 Analysis28362838283161
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_QM_QVRCSKPI_0000RCS QM KPI - Raw Data for Qlikview (Core Query)202224222224134
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_MPR_QM_0001RCS QM KPI - Synthesis (Core)97877745
ELEM/A/BW_QRY_ODS_QM02_9001BW Brazil - QM - Notification - Tasks 27241227
ELEM/A/QVPPV_BW_QRY_MVGSVQM_0003SPRINT - PUR: Non Conformance Analysis (Core Query) - QV64445427
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_0002GSV 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)1131118
ELEM/A/BW_QRY_MPR_QM_0003RCS QM KPI - Lots Waiting for UD (Core)1121117
ELEM/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)1111116
ELEM/A/BW_QRY_MPR_QM_0005RCS QM KPI - Average Delay for UD (Core)1111116
ELEM/A/BW_QRY_MPR_QM_0006RCS QM KPI - Lot with Incorrect Valuation (Core)1111116
ELEM/A/BW_QRY_MPR_QM_0007RCS QM KPI - Lot Long Term with No UD (Core)1111116
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/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

https://drive.google.com/drive/folders/0BwfSNqWU_-PscU1Lb3NOSENRTmM

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

Main functionalities

Broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution

 

  • No labels