...
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
...
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/open?id=1OY7cnX5ZIxSJid4HBdZ82-GXqvulC65wzd2dwqbPDuk 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/open?id=0BwM8zQWmqesDfm9tYWgyUmRnaWRvRmNITDcyV1htTkRHSVo1RXkzZWtqbmpfNXUyTURaRXM
/drive/folders/1mWeXJBTkb-FjWI0vAGBNwKbLCRC-ON3K
Functional and Technical rules
Rules & Explanations
https://drive.google.com/open?id=1_5DDd6-5bHXyiVfYyEuQ9nwOG7n6XP8E2UMsVjNqm-U /file/d/1adGTdxa3RfOmgMiClLAgvhXplfDhsCOAXRGt8JQtb10/view
Historical cube - CUB_EHS01 (EHS KPI (Histo))
...
https://wiki.solvay.com/x/YQBL
Dependencies with other applications
...
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)
...
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.
...
Stop the loading of the old flow concerning KPI on products compositions