General presentation
Objective of the application
This application is used to follow:
- the Quality Results for Shipment
- As source of MiniCus or MniTab application
- To follow the Limites, Quantitative and qualitative results of the Quality inspections.
- Statistical ratios and calculations on the quality inspections results
Tool Leader + IT leader of the application:
Usage information
History
This application has been created in 2006 for Rhodia data (WP1). It was upgraded for Solvay data (PF1) in 2017. At the same time data from both Rhodia and Solvay was consolidated and optimized in a unique multiprovider, and the number of used queries was reduced to keep only those necessary
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 |
|---|---|---|
| ZR_RCS_CA_M14 | QM - Quality Management | This role gives access to the Query and Workbooks through role menus. |
| ZBI_RCS_QM_A02 | Quality Results Application - End User role | This role controls access to the application. |
| ZR_*_CA_P01 | Analysis company - XXX | Role to control access to data based on the company code, with XXX being the name of the company code. There is a many role as there is company code. In the new multiproviders created, this role is not relevant. |
| ZR_*_CA_P02 | Analysis - Plant XXX - YYY | Role to control access to data based on the plant, with XXX being the name of the plant, and YYY its description. There is a many role as there is plants. In the new multiproviders created, the infoobject used for authorization is C_PLANT. |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| ZBI_QM | This object gives global access to objects relevant for authorization yet not relevant for the related multiprovider. This is especially true for the controlling area (CO_AREA) |
| ZXXXXCAP01 | This object gives access to the various infoobjects company code related and relevant for authorization, with XXXX being the company code considered. |
| ZXXXXCAP02 | This object gives access to the various infoobjects plant related and relevant for authorization, with XXXX being the plant considered. |
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
BW I&P - Quality Management (QM) Dataflow
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Dependencies with other applications
Data loadings
Info providers and objects loaded
Loading frequency
Main Process Chains
| Process Chain | Code | Comments |
|---|---|---|
| META - D - QM - Master Chain | PC_QM_00 | Loading of data in delta mode |
| META - ADH - QM - Inspection Results Init | PC_QM_19 | Used to reload data for dataflow QM. Caution: The loading of the two DSO ODS_QM07 and ODS_QM01 for Rhodia is not included. |
| TD - ADH - QM - Deletion of Inspection Results data | PC_QM_18 | Used to delete data in infoproviders |
| TD - Y - QM - Inspection Results - Historic Data | PC_QM_07 | Updates the infocubes containing historical data for both Solvay and Rhodia Data with the previous year. The infocubes containing the last 5 years of data is emptied and reloaded accordingly. |
| TD - Y - QM - Qual. Insp. Res. for deliv. - Historic Data | PC_QM_17 | Updates the infocubes containing historical data for both Solvay and Rhodia Data with the previous year. The infocubes containing the last 5 years of data is emptied and reloaded accordingly. |
Sub Process Chains
| Process Chain | Code | Comments |
|---|---|---|
| MD - D - QM - Textes QM | PC_QM_24 | Loading of the texts for specific QM MD |
| TD - D - QM - Propagation Layer - Solvay | PC_QM_01 | Used to load Solvay data for the propagation layer for every QM projects |
| TD - D - QM - PL - Inspection Results (Solvay) | PC_QM_12 | Used to load Solvay data for the propagation layer for Inspection Results |
| TD - D - QM - Propagation Layer - Rhodia | PC_QM_02 | Used to load Rhodia data for the propagation layer for every QM projects (Currently not used) |
| TD - D - QM - Business Layer - Rhodia | PC_QM_03 | Used to load Rhodia data for the business layer for every QM projects |
| TD - D - QM - BL - Inspect. Results for Deliveries - Rhodia | PC_QM_09 | Used to load Rhodia data for the business layer for Inspection Results for deliveries |
| TD - D - QM - BL - Inspection Results - Rhodia | PC_QM_08 | Used to load Rhodia data for the business layer for Inspection Results |
| TD - D - QM - Business Layer - Solvay | PC_QM_04 | Used to load Solvay data for the business layer for every QM projects |
| TD - D - QM - BL - Inspect. Results for Deliveries - Solvay | PC_QM_10 | Used to load Solvay data for the business layer for Inspection Results for deliveries |
| TD - D - QM - BL - Inspection Results - Solvay | PC_QM_11 | Used to load Solvay data for the business layer for Inspection Results |
| TD - ADH - QM - BL - Insp Res for Del - Rhodia - Init < 2013 | PC_QM_25 | Used when loading Rhodia data for project inspection results for deliveries. Given the volumetry generated, it's easier to load the data year by year. This PC loads data depending on the creation date up to 31.12.2012 |
| TD - ADH - QM - BL - Insp Res for Del - Rhodia - Init >=2013 | PC_QM_26 | Used when loading Rhodia data for project inspection results for deliveries. Given the volumetry generated, it's easier to load the data year by year. This PC loads data depending on the creation date from 01.01.2013 |
| TD - ADH - QM - BL - Insp Res for Del - Solvay - Init < 2013 | PC_QM_27 | Used when loading Solvay data for project inspection results for deliveries. Given the volumetry generated, it's easier to load the data year by year. This PC loads data depending on the creation date up to 31.12.2012 |
| TD - ADH - QM - BL - Insp Res for Del - Solvay - Init >=2013 | PC_QM_28 | Used when loading Solvay data for project inspection results for deliveries. Given the volumetry generated, it's easier to load the data year by year. This PC loads data depending on the creation date from 01.01.2013 |
| TD - D - QM - Reporting Layer - Rhodia | PC_QM_05 | Used to load Rhodia data for the reporting layer. |
| TD - D - QM - RL - Inspect. Results for Deliveries - Rhodia | PC_QM_15 | Used to load Rhodia data for the reporting layer for inspection results for deliveries. |
| TD - D - QM - RL - Inspection Results - Rhodia | PC_QM_13 | Used to load Rhodia data for the reporting layer for inspection results. |
| TD - D - QM - Reporting Layer - Solvay | PC_QM_06 | Used to load Solvay data for the reporting layer. |
| TD - D - QM - RL - Inspect. Results for Deliveries - Solvay | PC_QM_14 | Used to load Solvay data for the reporting layer for inspection results for deliveries. |
| TD - D - QM - RL - Inspection Results - Solvay | PC_QM_16 | Used to load Solvay data for the reporting layer for inspection results. |
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