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

Compare with Current View Page History

« Previous Version 3 Next »

General presentation

Objective of the application

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

Usage information

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 5124895534834795053 021
MPRO/A/MPR_PM004WBP_400/MPRO/A/MPR_PM0042672522882532642731 597
MPRO/A/MPR_PP02RCS PP KPI MultiProv646274484860356
MPRO/A/MPR_QMMPR_QM353541353537218
MPRO/A/MVEHKP01WBP_400/MPRO/A/MVEHKP011010 404444148
MPRO/A/MPR_FPF&P MultiProvider222023382222147
MPRO/A/MPR_OTCOTC MultiProvider232724212225142
MPRO/A/MPR_P2P01P2P KPI222034212222141
MPRO/A/MPR_COAMPR_COA202035212222140
MPRO/A/MPR_EHS01WBP_400/MPRO/A/MPR_EHS0126202360 75
MPRO/A/MPR_FAFA MultiProvider232311 0 57

 

Statistics 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 5124895534834795053 021
ELEM/A/BW_QRY_MPR_PM004_QVRCSKPI_0000RCS PM KPI - Raw Data for Qlikview (Core Query)2402402762532642731 546
ELEM/A/BW_QRY_MPR_PP02_QVRCSKPI_0000RCS PP KPI - Raw Data for Qlikview (Core Query)484860484860312
ELEM/A/BW_QRY_MPR_COA_QVRCSKPI_0001RCS QM KPI - Coa First Time (QV)202035212222140
ELEM/A/BW_QRY_MPR_FP_QVRCSKPI_0000RCS F&P KPI - Raw Data for Qlikview (Core Query)202023292222136
ELEM/A/BW_QRY_MPR_QM_QVRCSKPI_0000RCS QM KPI - Raw Data for Qlikview (Core Query)202224222224134
ELEM/A/BW_QRY_MPR_P2P01_QVRCSKPI_0000RCS P2P KPI - % PR created via MRP (Core)202029212222134
ELEM/A/BW_QRY_MPR_OTC_QVRCSKPI_0000RCS OTC KPI - Raw Data for Qlikview (Core Query)202023212225131
ELEM/A/BW_QRY_MVEHKP01_QVRCSKPI_0001RCS EHS KPI - Synthesis for Qlikview (Core) 1 404444129
ELEM/A/BW_QRY_MPR_EHS01_QVRCSKPI_0000RCS EHS KPI - Synthesis for Qlikview (Core Query)2020236  69
ELEM/A/BW_QRY_MPR_FA_RBS_0001RCS FA KPI - Manual adjust in CO-PA (Doc type =Z) (Core)20236   49
ELEM/A/BW_QRY_MPR_QM_0001RCS QM KPI - Synthesis (Core)97877745
ELEM/A/BW_QRY_MPR_PP02_0001RCS PP KPI - Synthesis (Core)121010 0 32
ELEM/A/BW_QRY_MPR_PM004_0001RCS PM KPI - Synthesis (Core)1088 0026
ELEM/A/BW_QRY_MPR_PM004_0004RCS PM KPI - Nr Orders CRTD and REL (Core)1111  013
ELEM/A/BW_QRY_MPR_FP_0001RCS F&P KPI: Synthesis (Core)2  90 11
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_MVEHKP01_0001RCS EHS KPI - Synthesis (Core)43    7
ELEM/A/BW_QRY_MPR_FA_0001RCS FA KPI - Manual adjust in CO-PA (Doc type =Z) (Core)1 5   6
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_MPR_PM004_0002RCS PM KPI - % Orders with Equipment (Core)411  06
ELEM/A/BW_QRY_MPR_OTC_0002RCS OTC KPI - Delivery (Core) 50   5
ELEM/A/BW_QRY_MPR_P2P01_0002RCS P2P KPI - % PR created via MRP (Core)  5   5
ELEM/A/BW_QRY_MVEHKP01_0002RCS EHS KPI - Nb of product without composition (Core)22    4
ELEM/A/BW_QRY_MVEHKP01_0003RCS EHS KPI - Nb of product with composition at 100% (Core)22    4
ELEM/A/BW_QRY_MVEHKP01_0004RCS EHS KPI - Nb of Materials without DG Master Data (Core)22    4
ELEM/A/BW_QRY_MPR_OTC_0004RCS OTC KPI - Sales Order Using Qty and Fixed Date (Core)120   3
ELEM/A/BW_QRY_MPR_EHS01_0000RCS EHS KPI - Synthesis (Core)3 0 0 3
ELEM/A/BW_QRY_MPR_PM004_0003RCS PM KPI - % Orders with MP (Core)111  03
ELEM/A/BW_QRY_MPR_PM004_0005RCS PM KPI - % Notifications with Item (Core)111  03
ELEM/A/BW_QRY_MPR_PP02_0002RCS PP KPI - Process Orders in the past (Core)111 0 3
ELEM/A/BW_QRY_MPR_PP02_0003RCS PP KPI - Planned Orders in the past (Core)111   3
ELEM/A/BW_QRY_MPR_PP02_0004RCS PP KPI - Total Production Orders in the past (Core)111   3
ELEM/A/BW_QRY_MPR_PP02_0005RCS PP KPI - COGI (Core)111   3
ELEM/A/BW_QRY_MPR_FA_0003RCS FA KPI - Synthesis (Core)2   0 2
ELEM/A/BW_QRY_MPR_OTC_0001RCS OTC KPI - Synthesis (Core)2 0 0 2
ELEM/A/BW_QRY_MPR_P2P01_0001RCS P2P KPI - Synthesis (Core)2   0 2
ELEM/A/BW_QRY_MPR_OTC_0003RCS OTC KPI - Shipment (Core)  1   1
ELEM/A/BW_QRY_MPR_EHS01_0002RCS EHS KPI - Nb of product with composition at 100% (Core)1 0   1
ELEM/A/BW_QRY_MPR_EHS01_0001RCS EHS KPI - Nb of product without composition (Core)1 0   1
ELEM/A/BW_QRY_MPR_EHS01_0003RCS EHS KPI - Nb of Materials without DG Master Data (Core)1 0   1
ELEM/A/BW_QRY_MPR_FP_0003RCS F&P KPI: % of obsolete combinations (Core)    0 0
ELEM/A/BW_QRY_MPR_FP_0002RCS F&P KPI: % of volume with sales forecasts (Core)    0 0
ELEM/A/BW_QRY_MPR_FP_0004RCS F&P KPI: SOIP Process (Core)    0 0

 

The BW RCS KPI application is more used as source of QV dashboard.

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

Reporting documentation drive folder:

https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE

Exemple of dataflow overview :

Template Application name DataFlow

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