...
...
Contacts & Organisation
Importants contacts and BW team roaster
...
...
Exploitation
Rules, best practives and processes for the process chains monitoring.
...
...
Footprints Process
Footprint processes for support teams and competence center
...
...
How To
Various How To guides for BW support and maintenance.
...
...
| Info |
|---|
...
...
...
...
BW Developer Guide
Rules, best pratices and documentation on BW workbench design + All tips for the development (naming convention)
...
...
Tech Troubleshooting
Technical troubleshooting : a list of issues and errors with solutions.
...
...
Query Design
Rules, best pratices & documentation for query design and maintenance.
...
...
Useful Links
Importants links for BW.
...
...
Broadcasting
Rules, best pratices and documentation about broadcasting (Scheduled reports)
Contacts & Organisation
Management
Managers | Description |
|---|---|
Christophe Audefroy | BW Competence Center Manager |
Guillaume Thevenet | BW Maintenance Manager |
All documents in file format can be found in the Reporting Google Drive : https://drive.google.com/a/solvay.com/#folders/0B_fH_eB4PSMwc1ppRXVrVXh0ZXM |
| Table of Contents | ||
|---|---|---|
|
Contact Lists
List | Description |
|---|---|
sbs-is-appli-techno-report.all@solvay.com | All reporting Team, including external |
BW Support | |
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
| sbs-is-appli-help@solvay.com | Helpdesk in charge of opening new URs |
Reporting coordinators by process
| Process | Coordinator | Applications in WBP | Application in PQ2 | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Finance Data and Reporting (ex-RtR) |
|
| |||||||||||||
IS Supply Chain M&S Data & Reporting (ex-OTC) |
| TR, OC, GTS, FIAR, Sales | |||||||||||||
IS Industrial and R&I Service Line (ex-I&P) |
- Dynasys : Laure Pichot-Place (or Lei Shen) - PM : Raphael Bert or David Tan | QM, PP, PM, VS, EHS, Dynasys(APO) | |||||||||||||
Procurement Data & Purchasing Solutions (ex-PtP) |
| Purchase, SPRINT, GSV, PU, IM | |||||||||||||
SERVICE LINE HR (ex-HR) | Solvay HR |
Position
Name
CC Manager
AUDEFROY Christophe
Maintenance Manager
Who does what
| Info |
|---|
R h1. Responsible. C Collaborate |
Action/Team | Helpdesk(HDA) | Reporting Support | Reporting Process |
|---|
Support (RPS)
Reporting Process Expert (RPE)
Coordinators | Domain Process Leader (DPL) | Reporting Competence Center | SAP Technical Team |
|---|
Security Team |
|---|
General Support |
User Training |
R (Zone) |
Basic Support (Level 1) | R (Zone) | C (Zone) |
Normal Support (Level 2) |
R |
(Zone) |
Advanced Support (Level 3) |
R ( |
WW) |
Access | |
|---|---|
Password reset/unlock | R |
Account Creation/Modification/Lock |
R | ||||||
Access troobleshooting |
R |
C | |||||
Coordination/Communication | |||||
|---|---|---|---|---|---|
Support UR Follow up |
C |
(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 ( |
WW) |
Promote development best pratices |
R |
Documentation | |
|---|---|
Technical Documentation |
R |
User Documentation (Application Specific) |
R |
C |
User Documentation (General Guides) |
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 | 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