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

Provide some history of the application : When was it created ? What was the initial project ? Who was the original requestor ? If possible provide link to the project information

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

Use the google presentation below as a template. This google presentation must be saved in the Reporting GDrive folder under the corresponding application. Then post the link to the document here.

Reporting documentation 

https://drive.google.com/drive/folders/11ulxohbwMPcsRv6ATP3PJH8hhwBEASwn

dataflow overview :

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


Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Detail of main topics with explanations of the rules and only the main + special rules about queries to run and use in the correct way

Dependencies with other applications

Dependencies with other application (BW, QV, Externals tools like PVelocity or Dynasis etc...

Data loadings

Info providers and objects loaded


Loading frequency

Weekly loadings.

Average performance

if possible, give some information on average process chain duration, amount of data loaded and total data volume example: daily process chain loaded in 30 min, weekly chain loaded in 1h15, with around 2k to 10k lines in DELTA mode for a total of 10M lines in cube. The purpose is to give a general overview of the volume of data managed y the application


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

Give details if any historisation is done, example: keep only data greater than beginning of Y-3

Reporting

Queries End User Documentation

Query end user documentation should be created in the public "Customer Support Wiki" space under the corresponding BW application page : BW - Application. Technical query query documentation, if necessary should be added as a sub-page of this documentation using the BW Technical Query Documentation template.

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

Main queries

List the most important and complex queries only with a link to the documentation

Main functionalities

Give detail on all complex functionalities: list most important and/or complex KPI, query jump, alerts

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

Give the list and explanation on the known, not-solved, bugs.

Recurring procedure

List recurring procedures

Planned Evolution

Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016


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:


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