General presentation
Objective of the application
This solution is part of the RCS KPI application. It offers several EHS KPI about commercial products compositions and Dangerous Goods Master Data.
Reporting Coordinator: Célia Gonzalez-Roux
Usage information
Access given to around 200 users.
History
A review of the solution was delivered end of year 2015 in order to able to see KPI for Solvay GBUs.
Roles & Access
Roles and access
| Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M29 | KPI - Key Performance Indicator | Role menu for "KPI - Key Performance Indicator" |
| ZBI_RCS_KPI_A02 | Key Performance Indicator - KPI - End User Role | Application Role:
|
Authorization objects
Link to the BW Catalog of role
https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
Dataflow overview
Cube CREHKP01 - New solution dataflow:
https://drive.google.com/file/d/1vWJJMrH15AaoroH_tntjwubAbk-4S-sYA6UzDz0cHSc/view
Cube CUB_EHS01- Old solution dataflow (still available for historical data and Dangerous Goods KPI):
https://wiki.solvay.com/x/YQBL
Reporting documentation drive folder:
Functional and Technical rules
Rules & Explanations
https://drive.google.com/open?id=1_5DDd6-5bHXyiVfYyEuQ9nwOG7n6XP8E2UMsVjNqm-U
Historical cube - CUB_EHS01 (EHS KPI (Histo))
This cube was used for all EHS KPI. It is now only used for historical KPI (before 12/2015) and also the dangerous goods indicators.
Rules concerning this flow are described here:
https://wiki.solvay.com/x/YQBL
Dependencies with other applications
DSO DPEHKP01, DPEHS02 and DPEHAD01 are used for the EHS application (EHS - Admin Reports).
Data loadings
Info providers and objects loaded
Main Process Chains
PC_EHS_ASSESSMENT and EHS_MASTER_DATA should run the first work day of the month, else KPI EHS of month M-1 may not reflect exactly the M-1 state.
Process Chain | Code | Type | Frequency | Comments |
|---|---|---|---|---|
| EHS Assessment Report | PC_EHS_ASSESSMENT | SLAVE |
|
|
| EHS : TD - D - RCS KPI | PC_EHS_KPI_001 | SLAVE |
|
|
| EHS Dailly MD Attributes | EHS_MASTER_DATA | SLAVE |
|
|
Loading frequency
KPI on compositions Process Chain is started monthly every 1st working day.
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
Wiki Support : https://wiki.solvay.com/x/JwI8
Queries
There is one global core query, with all KPI: RCS EHS KPI - Synthesis (Core) (BW_QRY_MVEHKP01_0001)
A copy of this query is used for Qlikview reporting: RCS EHS KPI - Synthesis for Qlikview (Core) (BW_QRY_MVEHKP01_QVRCSKPI_0001)
3 subsets of the global query are used for each workbook sheets:
RCS EHS KPI - Nb of product without composition (Core) (BW_QRY_MVEHKP01_0002)
RCS EHS KPI - Nb of product with composition at 100% (Core) (BW_QRY_MVEHKP01_0003)
- RCS EHS KPI - Nb of Materials without DG Master Data (Core) (BW_QRY_MVEHKP01_0004)
Workbooks
There are 2 Analysis workbook using KPI EHS queries:
RCS EHS KPI (BW_WBK_KPI_0008) : use the 4 EHS KPI queries.
RCS Synthesis KPI (BW_WBK_KPI_0009) : use the global core EHS KPI query and other KPI queries not linked to EHS.
There is also Analyser workbooks for broadcasts use.
In the future, only the Qlikview reporting may be relevant.
Broadcast
There was a broadcast that was not updated by the new solution => should be replaced by Qlikview.
Maintenance
Known bugs
Recurring procedure
Planned Evolution
Stop the loading of the old flow concerning KPI on products compositions