| 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. |
| Applications Documentation
Documentation of the applications : data flows, extractors, info-provider designs and technical query documentation. | 
| Account Management
How user accounts and security are managed. Procedures, rules and design documentation. |
| 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 |
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
Support (RPS) | 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 |
COPC | Production Costs | | Cost estimates, components & Activities, material yeld... |
CBS | Corporate Business Service | | 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 |
FIAP | Account payables | | Vendor accounting : balances, overdues... |
FIAR | Account Receivables | | Customer accounting : balances, overdues, credit... |
FIGL | General Ledger | | General ledger reporting : balances |
FISCA | Supplier Credit Automation | | Reports for the supplier credit optimisation process |
FIWC | Working Capital | Public Doc | Working Capital by company or GBU reports |
GSV | Global Spent Visibility | | Purchasing function reporting |
GTS | Global Trade Services | | Import/Export reporting |
IM | Stocks | Public Doc | Inventory and stock movements reports |
KPI | RCS Key Performance Indicators | | 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 |
SRM | Purchasing Shopping Cart | | Reporting on BIP Purchasing Shopping Cart |
TR | Transport Costs | | Shipment costs analysis reporting |
VS | Value Stream | | Industrial Dashboard detail reports by value stream |
Other applications (non-user)
Description | Usage |
|---|
Integratrated Margins | Calculation of integrated margins for BO |
EHS | EHS master data for BO |
Qlikview Sources | Queries used as sources to load data into the Qlikview Dashboards |
Useful Links