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

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
ZBI_RCS_KPI_A02Key  Performance Indicator - KPI - End User RoleApplications
ZR_RCS_CA_M29KPI - Key  Performance IndicatorMenus
   

Authorization objects

List of autorisation objects mandatory for the application.

Authorization objectExplanation
No authorization object 
  
  

Dataflow overview

Reporting documentation 

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

dataflow overview :

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

 

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Dependencies with other applications

Data loadings

Info providers and objects loaded

 

Loading frequency

Weekly loadings.

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

https://wiki.solvay.com/pages/viewpage.action?pageId=3932719

Main queries

Main functionalities

Broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution

 

  • No labels