| Contacts & Organisation | ||
| Exploitation | ||
| Footprints Process |
| How To |
| Applications Documentation |
| Account Management |
| BW Developer Guide |
| Tech Troubleshooting |
| Query Design |
| Useful Links |
| Broadcasting |
Contacts & Organisation
Management
Managers | Description |
|---|---|
Christophe Audefroy | BW Competence Center Manager |
Guillaume Thevenet | BW Maintenance Manager |
Lists
List | Description |
|---|---|
sbs-is-appli-techno-report.all@solvay.com | All reporting Team, including external |
RHD-RCS SUPPORT BW | Europe BW Support |
SBS-IS-Appli-Techno-Report Employees | All reporting team, excluding externals |
is-qpsupport@solvay.com | SAP Technical Team |
RHD-RCS SUPPORT SECURITE | Security team in charge of account management |
Who is who
Reporting Coordinator
Stream | Name |
|---|---|
P2P | Duarte COSTA |
Indus&P | Célia GONZALEZ- |
RTR | Sandrine Micollet |
OTC | Sandra Silveira |
HR | ?? |
Competence Center
Position | Name |
|---|---|
CC Manager | AUDEFROY Christophe |
Maintenance Manager | THEVENET Guillaume |
Who does what
R h1.Responsible. C Collaborate
Action/Team | Helpdesk(HDA) | Reporting Support | Reporting Process | Reporting Process Expert (RPE) | Domain Process Leader (DPL) | Reporting Competence Center | SAP Technical Team | MAGDA |
|---|---|---|---|---|---|---|---|---|
General Support | ||||||||
User Training |
| R (Zone) | R (Zone) |
|
|
|
| |
Basic Support (Level 1) | R (Zone) | C (Zone) |
|
|
|
|
| |
Normal Support (Level 2) |
| R (Zone) | C (Zone) |
|
|
|
| |
Advanced Support (Level 3) |
|
| R (Zone) |
|
| R (WW) |
| |
Access | ||||||||
Password reset/unlock | R |
|
|
|
|
|
| |
Account Creation/Modification/Lock |
|
|
|
|
|
|
| R |
Access troobleshooting |
| R |
|
|
|
|
| C |
Coordination/Communication | ||||||||
Support UR Follow up |
| C (Zone) | R (Zone) |
|
|
|
| |
Maintenance UR Follow up |
|
|
|
| C | R |
| |
Action plan to improve usage |
|
| R (Zone) | R (WW) |
|
|
| |
Reinforce reporting applications usage |
|
| R (Zone) | R (WW) |
|
|
| |
Implement new / optimize reporting solutions |
|
|
| R (WW) |
|
|
| |
Project Coordination |
|
|
| R |
|
|
| |
Relation with DSI, Functions, RBS |
|
|
| R/C* | R/C* |
| ||
Relation with DPL |
|
|
| R | C |
|
| |
Ensure good data administration |
|
| R (Zone) | R (WW) |
|
|
| |
Promote development best pratices |
|
|
|
|
| R |
| |
Documentation | ||||||||
Technical Documentation |
|
|
|
|
| R |
| |
User Documentation (Application Specific) |
|
|
| R |
| C |
| |
User Documentation (General Guides) |
| R | R |
|
| C |
| |
Evolution/Correction | ||||||||
Core Query publication |
|
|
|
|
| R |
| |
Modelisation/Back End Developments |
|
|
|
|
| R |
| |
Architecture definition |
|
|
|
|
| R |
| |
Master Data management |
|
|
|
|
| R |
| |
Broadcast management |
| R (Zone) | R (Zone) |
|
| C |
| |
Core reports |
|
| C | C | C | R |
| |
Functional validation |
|
|
| C | R |
|
| |
Functional specifications |
|
|
| R | R |
|
| |
Technical specifications |
|
|
| C | C | R |
| |
Cleaning of un-used queries |
|
|
|
|
| R |
| |
Data reloading/correction |
|
|
|
|
| R |
| |
Non-Core reports |
|
| R (Zone) | R (Zone) |
|
|
| |
Technical | ||||||||
Manual Order Transportation |
|
|
|
|
|
| R | |
Server-side update/reset |
|
|
|
|
|
| R | |
SAP Notes application |
|
|
|
|
| C | R | |
Monitoring | ||||||||
Loading Monitorings |
|
|
|
|
| R |
| |
ISSP Communication on availibility |
|
|
|
|
| R |
| |
Broadcast monitoring |
| R |
|
|
|
|
|
Roles and responsabilities
Reporting Process Support (RPS)
The Reporting Process Support (RPS) is part of the Delivert Team and his role/responsabilities are to :
- Provide advanced support on reporting solutions to users in the zone; animate and follow-up, in a proactive manner, action plans to ensure reporting solutions are used in a extensive and proper way. (governance)
- Provide advanced support on reporting solutions aligned with the limitation of know how / skills (BO, BW, Qlikview, etc
- Sustain and reinforce reporting application usage in the zone – transversal, all tools, all solutions, all streams.
- Implement and/or optimize reporting “new” applications for the zone and organize, with help of local process supports, the roll-out of initiatives pushed by Global Functions via Reporting Experts and Process Experts – transversal, all tools, all solutions, all streams.
- Ensure good level of Data Administration for reporting in the Zone – increase quality and trust in data – transversal, all tools, all solutions, all streams.
Reporting Competence Center (CC)
The role and responsabilities of the Reporting Competence Center (CC), part of the Techno Stream are :
- All backend developments:
Universes/Cubes
Interfaces with other applications
Database modeling
Management of ETL (extraction, transformation, load) processes - Creation and maintenance of complex reports
- Core queries maintenance and publication
- Support to Reporting PS on report edition and complex troubleshooting
- Promotion of best practices on developments
- Decision on tools and architecture to be applied for reporting
Reporting Process Experts (RPE)
The reporting Process Experts (which are part of the Streams) have the role/responsabilities to :
- Manage reporting tasks included in projects
- Lead functional specification tasks
- Coordinate report development in recurrent mode (maintenance)
- Validate requests regarding reports : relationship with DSI and others requestors
- Relationship with DPL for functional validation
- Coordinate deployment and rollout
- Relationship with DSI and GBU :
Governance
Process optimization and best practices
To identify requirements and needs
Promotion and reuse of existing core reports
Follow up usage KPI
Domain Process Leaders (DPL)
Their role is to :
- Ensure reporting needs will be directed towards Reporting Leaders (not only BO+BW)
- Collaborate on functional specification
- Collaborate to clarify requirements during technical specification process
- Collaborate on Functional validation for reports
- Collaborate on deployment and rollout, if needed.
Footprints Process
Applications Documentation
User Applications
Code | Name | Public doc | Description |
|---|---|---|---|
AU | Authorisation Follow Up | RCS Authorisations - GRC | |
CATS | Time Sheet |
| Cross Application Time Sheets reporting from RCS |
Production Costs |
| Cost estimates, components & Activities, material yeld... | |
| Functions fixed costs and Projects costs for RCS and Solvay | ||
EHS | Environment, Health and Safety |
| Indicators about dangerous materials |
FC2 | Fixed Costs |
| Enterprise Fixed Costs reporting |
FIAA | Fixed assets accouting |
| Reporting on the RCS fixed assets |
| Vendor accounting : balances, overdues... | ||
| Customer accounting : balances, overdues, credit... | ||
| General ledger reporting : balances | ||
FISCA | Supplier Credit Automation |
| Reports for the supplier credit optimisation process |
Working Capital by company or GBU reports | |||
| Purchasing function reporting | ||
GTS | Global Trade Services |
| Import/Export reporting |
IM | Stocks | Inventory and stock movements reports | |
| Statistics on RCS usage | ||
OC | Order Changes |
| Sales orders history reporting |
PM | Plant Maintenance | Maintenance orders, notifications and operations (hours/costs/counting) reporting | |
PP | Production Planning |
| SOIP Reports - Actual/MRP production, Consumption, Sales & Procurement |
PS | Project System |
| PEC, CASH, CAPEX reporting - WBS elements costs |
PU | Purchasing For Plants |
| Purchasing reporting for non-purchasing function users |
QM | Quality Management |
| QM Lots reporting : individual results and statistics |
| Reporting on BIP Purchasing Shopping Cart | ||
TR | Transport Costs |
| Shipment costs analysis reporting |
| Industrial Dashboard detail reports by value stream |
Other applications (non-user)
Description | Usage |
|---|---|
Integratrated Margins | Calculation of integrated margins for BO |
EHS master data for BO | |
Queries used as sources to load data into the Qlikview Dashboards |
Useful Links
Link | Description |
|---|---|
BW Rhodia production portal (WBP) | |
BW Rhodia quality portal (WBQ) | |
BW Rhodia development portal (WBD) - Last changed 14.03.2014 | |
BW Rhodia sandbox portal (WB1) => works only with Internet Explorer |