General presentation
Objective of the application
The objective of the application is to extract Key figures from several sources in order to calculate Industrial KPIs.
Then data will be consumed by Qlikview E2E Value Chain Dashboard.
Tool Leader: Diogo Paiva (IS SCM)
IT leader of the application: Craig Wanamaker (BW)
Reporting Coordinator: Diogo Paiva (IS SCM) / Meire Santos
Usage information
Number of users: tbd
Critical period: none
Geographical perimeter: worldwide
InfoArea:
Usage information
BW queries have been created to avoid data to Qlikview Dashboard and not to use them directly with Analysis for Office Tool.
History
This application is linked to the E2E VC Dashboard global project.
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Dataflow overview :
Functional and Technical rules on Workbench + Reporting
Functionnal Specification Document
BW Specification Document
Rules & Explanations
RFT (Right First Time) KPI
To calculate this KPI, we must get the result of the specific transaction ZWPP24A_1 (diplay "List 3") from both source system WP1 and PF1.
The same specific datasource DTS_ZBW_ZWPPT025 has been developed for each system.
It is based on table ZWPPT025.
All necessary fields to calculate the RFT KPI are in the current table expect the "Confirmed quantity". To get it, we use an append structure ZABIW_ZWPPT025 and the respective class ZDTS_ZBW_ZWPPT025.
The appened filed is ZCONFORM_QTY (Conform quantity used to calculate T0).
The ABAP code used to determine the conform quantity is a copy of the one used in the transaction ZWPP24A_1 (check the program ZWPPR01400_1).
RFT KPI (%) is determined by the formula Conform Quantity / Total Batch Quantity.
It is calculated directly on the Query.
Dependencies with other applications
The BW application provide data to Qlikview E2E VC Dahboard application.
Data loadings
Info providers and objects loaded
Scope of data loaded
Both ADSO AASCE2E01 and AASCE2E02 in acquisition layer are loaded by 2 FULL DTPs respectively from WP1 and PF1 SAP source system.
We load records with movement date >= 01.01.[Current Year - 2].
Average number of lines in ZWPPT025 table (July 2020) :
- WP1 => 1.446.532 records
Transactional data process chain
Transactional data are loaded by the process chain PC_SC_E2E_01.
Loading frequency
Data are loaded every day at 06:00 AM CET.
Average performance
| Key Figure | Estimation |
|---|---|
| ~ 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
We load records with movement date >= 01.01.[Current Year - 2], to keep the last 3 years of data.
Reporting
Queries End User Documentation
Main queries
Main functionalities
Broadcast
Maintenance
Known bugs
Recurring procedure
Planned Evolution
PF1 RFT KPI BW dataflow is build but not into production. We are waiting for implementation of transaction on PF1 SAP system.