Versions Compared

Old Version 5

changes.mady.by.user THEVENET, Guillaume

Saved on

compared with

New Version Current

changes.mady.by.user SWAMI-ext, Shivani Siddhrameshwar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Table of Contents

General presentation

Objective of the application

https://drive.google.com/drive/folders/0BwfSNqWU1uBvCrqBuF57HeWpXoH3bZMmlmz_-PsS3ZCUkhES0JUS2cFJTkO

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_-PscHpEMmllNkxoZTg11ulxohbwMPcsRv6ATP3PJH8hhwBEASwn

dataflow overview :

https://drive.google.com/drive/folders/0BwfSNqWU_-PsV0Zoekl3N2toVTA 1YQP-V88LgeiIVuSJaZYekvw-UsmNyYqn


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

2 process chains exist for KPI broadcast but no more used since last year or more.

BD_KPI_5 Broadcast KPI - 5th working day of month

BD_KPI_11 Broadcast KPI - 11th working day of month

Maintenance

Known bugs

Recurring procedure

Planned Evolution


3744382- We have a data issue on field No of Process Orders (Last 12 months) (A) on the query BW_QRY_MPR_PP02_QVRCSKPI_0000 since the month August 2019.

Issue: No Process Orders (Last 12 months) key figure value showing less values from 08.2019. Reason for this is Full DTP changed to Delta by mistake in ODS_PP01 -> DSO_PP05    


Solution:

  • Created Copy DSO(ADSO_PP05) based on DSO_PP05 and Created transformations   between ADSO_PP05→ DSO_PP05 && DSO_PP05-->ADSO_PP05
  •  There is no mapping of CALDAY between DSO_PP05-->ADSO_PP05 and CALDAY mapping will be between ADSO_PP05 → DSO_PP05


Maintain global filter and Transformation end routine between ADSO ADSO_PP05 -> ODSO DSO_PP05

Image Added



Image Added



  •   DSO_PP05 does not keep RECORDMODE. We have hard coded K_COUNTER as '1’ one in transformations ADSO_PP05 ->DSO_PP05
  • Loaded data of 7.08.2019 and 13.08.2019 from DSO_PP05-->ADSO_PP05. When loading data reverse from ADSO_PP05 → DSO_PP05 read CALDAY from global filter as 13.08.2019.


  •  Next again loaded data of 20.08.2019 to DSO_PP05-->ADSO_PP05 and when do the load back again from ADSO_PP05 → DSO_PP05 read CALENDAR day of 20.8.2019 from global filter.



  •  We have to repeat these steps all the dates.
  •  Transport need to move after Monday (weekly load ) to production and data loads should complete before next week. 
  •  Data deletion and reload required in CUB_PP03 from three underlying DSO’s from 08.2019.
  • Process chain - RCS_PP_KPI transported, because not possible to convert Delta DTP to Full DTP in DSO_PP05 (Chain - RCS_PP_KPI). Replaced Delta DTP with new Full DTP in process chain RCS_PP_KPI and transported from Dev to Production
  • In future if transformations changes between ODS_PP01 -> DSO_PP05, reading global filter if it is not set, get the system date

Image Added