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
Access given to around 200 users.
A review of the solution was delivered end of year 2015 in order to able to see KPI for Solvay GBUs.
| 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:
|
Link to the BW Catalog of role
https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
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:
https://drive.google.com/drive/folders/1mWeXJBTkb-FjWI0vAGBNwKbLCRC-ON3K
https://drive.google.com/file/d/1adGTdxa3RfOmgMiClLAgvhXplfDhsCOAXRGt8JQtb10/view
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
DSO DPEHKP01, DPEHS02 and DPEHAD01 are used for the EHS application (EHS - Admin Reports).
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 |
|
|
KPI on compositions Process Chain is started monthly every 1st working day.
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 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 |
Give details if any historisation is done, example: keep only data greater than beginning of Y-3
Wiki Support : https://wiki.solvay.com/x/JwI8
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)
There are 2 Analysis workbook using KPI EHS 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.
There was a broadcast that was not updated by the new solution => should be replaced by Qlikview.
Give the list and explanation on the known, not-solved, bugs.
List recurring procedures
Stop the loading of the old flow concerning KPI on products compositions