-
SOFTWARE
SOFTWARESAP HCM & PayrollQuery Manager Query Manager Add-ons Document Builder Variance Monitor DSM for HCM HCM Productivity Suite FLOW GeoClockSAP Landscape & Test Data ManagementData Sync Manager (DSM) suite - System Builder/Shell Sync - Object Sync - Client Sync - Data Secure Archive CentralSupport & TrainingClient Central E-learning & trainingSAP Data Privacy & SecurityData Privacy suite - Data Secure - Data Disclose - Data Redact - Data Retain Soterion (GRC)
-
SERVICES
SERVICESSAP HCM & PayrollPRISM for HR & Payroll SAP SuccessFactors Integration monitoring Payroll reporting Report writingClient-specific DevelopmentCustom development SAP BTPSAP Landscape & Test Data ManagementPRISM Migrations to S/4HANA System Landscape Optimization (SLO) Managed data refresh servicesSAP Data Privacy & SecuritySAP data privacy assessment serviceMass data removal services Data privacy consultingCloud and Application Managed ServicesFunctional AMS Cloud management services Cloud migrations Basis managed services Private cloud hosting SAP on AWS SAP on Azure Premium Support Services RISE BRIDGE Managed Services
- All Solutions
- Request Estimate
-
Resources
Resources Blogs Read the latest updates on SAP SLO, SAP HCM, Data & Privacy, and Cloud Webinars Access expert insights in live and recorded webinars Video library Watch videos and improve your SAP knowledge
- About
SAP HCM reporting at Wales & West Utilities warms up
WALES & WEST UTILITIES AT A GLANCE
Wales & West Utilities operates the gas distribution network across Wales and the South West England regions of the United Kingdom.
It also provides the gas emergency service and delivers the iron mains risk reduction programme in those areas.
- Head office in Newport, Wales
- 19 depots across Wales and South West England
- Employs 1316 people
- Serving 7.5 million customers
- Service area of 1/6th of the UK
- SAP Landscape: SAP ECC, FI/CO, MM, HCM with ESS (not MSS), SRM, CRM, BI, GRC
BEFORE QUERY MANAGER
Wales & West’s SAP HCM reporting procedure was done with ABAP and was far from smooth. The process for obtaining the required report was protracted and drawn-out, which created challenges for the HR team who had to manage time usage, costs, wastage, use of individual skills, and more.
PROJECT SUCCESS: THE QUERY MANAGER SOLUTION
- Individuals/Teams submit a request for development to the Change Advisory Board (CAB).
- Requests are reviewed at the monthly CAB meetings.
- Approved requests are then sent to contractors, who supply a written Impact Assessment.
- The Impact Assessments are reviewed at the next monthly CAB meeting, where the final go-ahead is given.
- SAP ABAP development process – time-consuming, usually needing a number of days.
- User roles are amended by the security team.
- Conduct User Acceptance Tests of the report and test the assigned roles.
- Changes are moved to the Production server in the monthly transportation process.
The Business Case for purchasing Query Manager was based on development costs for a report intended to validate P11D information in the Company Car Infotype. The car information was compared to that in Travel Privileges and any inconsistencies were highlighted.
The quoted development time for this report to be developed as an ABAP, including Unit Testing and Delivery, was 28 days.
Some of the team at Wales and West had seen a recent demonstration of Query Manager and had realized its capabilities. It was clear that Query Manager was able to build the same report with a fraction of the effort at a comparable cost to the ABAP development cost. However, Query Manager was able to build all SAP HCM reports required by the business, and not just the Vehicle Validation Report.
Query Manager was purchased and part of the service included two days of on-site training. This proved invaluable, the training was thorough and gave the team confidence to build and create their own reports.
As a result, the Vehicle Validation Report was up and running in under two days. Importantly, return on investment was immediate and the purchase was completely justified. That particular report is still used as part of the pre-P11D validation process.
- ROI recovered after finishing the very first report
- Comprehensive delivered report library
- Thorough induction and training
- Query Manager community forum is perfect for sharing ideas and tips to get help with problems
- Outstanding technical support system
- Data errors greatly reduced within weeks
- The right people receive the right data at the right time
WHO WE'VE HELPED
BENEFITS OF QUERY MANAGER
Huge time savings
Flexibility when generating reports
Custom ABAP reports no longer necessary
Self-service reports for HR Manager
Less pressure on IT, e.g. Infoset customising eliminated
Central management of reports
Rapid implementation – less than a day
SAP authorisations are transferred
Only two days training necessary
