Access Management
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
| ZBI_RCS_SCRE_A01 | SCRE - Transport/Packaging Analysis | Access role |
| ZR_RCS_CA_M76 | Transport & Packaging Analysis | Menu role |
List of authorization objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| CPFCTR1_2 | GBU, role: ZR_*_CA_P05 |
| C_COMPCDE__C_AUTHMA | Authorization scope, role: ZR_*_CA_P00 |
| C_COMPPRS | PRS company, role: ZR_*_CA_P07 |
DataFlow
Overview
Technical Rules on Workbench
Reporting
Core queries:
BW_QRY_CPSCPK01_0001 - SCREEN - Pack. Inventory analysis - Detailed (Core Query)
BW_QRY_CPSCPK01_0002 - SCREEN - Pack. Inventory analysis - Aggregated (Core Query)
BW_QRY_CPSCPK02_0001 - SCREEN - Pack. Purchasing analysis (Core Query)
BW_QRY_CPSCPK03_0001 - SCREEN - Pack. Manuf. Consumption analysis (Core Query)
Qlikview queries:
QV_BW_QRY_CPSCPK01_0001 - SCRE - Pack. Inventory for QV / Stock (Core Query)
QV_BW_QRY_CPSCPK01_0002 - SCRE - Pack. Inventory for QV / Var. (Core Query)
QV_BW_QRY_CPSCPK02_0001 - SCRE - Purch. Pack. data for QV (Core Query)
QV_BW_QRY_CPSCPK03_0001 - SCRE - Pack. Consu. interface to QV (Core Query)
Dependencies with other applications
Screen packaging uses many providers as source of data (used in calculations view):
ABMMIM02R - Material Stock Non-cumulative (Rhodia)
ABMMIM02S - Material Stock Non-Cumulative (Solvay)
DBMMIC01 - Material stock snapshot - Rhodia
DBMMIC02 - Material stock snapshot - Solvay
DBFIGL03 - IM from FIGL: Line Items for Mat. Acct (M) - Rhodia Level 2
DBFIGL06 - IM from FIGL: Line Items for Mat. Acct (M) - Solvay Level 2
DBFIGL13 - IM from FIGL: Line Items for G/L Acct (S) - Rhodia Level 2
DBFIGL14 - IM from FIGL: Line Items for G/L Acct (S) - Solvay Level 2
DB_PUSL1 - PO : Schedule Line (Rhodia)
DB_PUSL2 - PO : Schedule Line (Solvay)
DB_PUHD1 - PO : Historical Data (Rhodia)
DB_PUHD2 - PO : Historical Data (Solvay)
ODSFIGL3 - FIGL: Line Items by Profit Centre
DPFIGL02 - FIGL: Line Items with Delta - Solvay
ABCOPP02 - IMEP - Rhodia
ABCOPP01 - IMEP - Solvay
Data Loading
Info Providers and objects loaded
Only one provider is loaded, the ADSO ABSCPK01 "Controlling - Screen Packaging" with data from composite provider CPSCPK01 "Controlling - Screen Packaging".
The composites providers CPSCPK02 and CPSCPK03 use calculations views.
Composite provider CPSCPK01 use calculation view and also ADSO ABSCPK01 (to improve the performance of queries)..
Loading frequency
ADSO ABSCPK01 is loaded during the working day with process chain PC_CT_TR_02 - "COSTA - Transactionnal Data 02 (Screen Pckg)".
The process chains starts at 6:30 am and waits the end of process chain PC_FREQUENTLY_LOAD_MAIN ' "01 Frequently Load PC Main" to load adso ABSCPPK01.
Data Quality Control
Operational Documentation
Procedures
<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>
Scheduling
<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>
Monitoring
<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>
Error Handling
<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>
Known Bugs
<List the existing bugs, its criticality, workarounds and resolution plan.>
Roadmap
<List past & future evolutions for the application (including links to MED/FSD/TSD>