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

Compare with Current View Page History

« Previous Version 18 Next »

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


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