General presentation

Objective of the application

https://drive.google.com/drive/folders/1uBvCrqBuF57HeWpXoH3bZMmlmz_FJTkO

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/11ulxohbwMPcsRv6ATP3PJH8hhwBEASwn

dataflow overview :

https://drive.google.com/drive/folders/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





  •   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

  • No labels