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.
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 (without selection) respectively from WP1 and PF1 SAP source system.
Average number of lines in ZWPPT025 table (June 2020) :
- WP1 => 6.800.000 records
Loading frequency
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
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.