General presentation
Objective of the application
SPM stands for "Sustainability Portfolio Management".
The objective of this application is to provide a "Sustainability view" for the reported sales.
Sales are extracted from P&L application in WBP and data is transformed to add a SPM dimension, through a sequence of steps, via lookup in mapping tables maintained in WBP.
SPM Master Data (SPM Product, SPM Application) are sourced from PF7.
Final report is in Qlikview.
List of contacts
Functional Owner of this application: Marc Piret (Sustainable Development & Energy (SDE)
- IS Reporting Leader: Diogo Paiva (IS Supply Chain M&S Data)
- BW Developer: Laressa Moretti (SBS IS)
Usage information
History
The project had 2 phases:
1 - First development covering most of the GBUs (pilot Aroma and Special Chem) - go live on Oct/2017
link to the project folder: https://drive.google.com/drive/folders/0BxkySrtHryoBejV1VG5CbmNwM3c
2 - Extension for GBU Specialty Polymers and Composite Materials - go live on Oct/2018
link to the project folder: https://drive.google.com/drive/folders/18bJbaF-EfKSDfYl5X1uWe25xiwa99ClU
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 |
|---|---|---|
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
Link to dataflow presentation:
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Dependencies with other applications
Data loadings
Info providers and objects loaded
Loading frequency
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