Query Manager makes Straumann smile
Straumann uses Query Manager™ to generate automated SAP HR reports and to check data quality
50 queries per week
An average of >500 runs per month
Automated SAP HR reports
Straumann's challenges
Before working with EPI-USE Labs, Straumann had been using standard SAP ad hoc queries. All SAP/HCM users had been responsible for running these queries.
With constant time pressures and a lack of specific responsibilities in HR, Straumann faced insufficient data quality, reporting errors and general inefficiency.
I love the possibility in Query Manager to be able to check objects, even if no value has been added (value is null). This isn’t possible with SAP standard functions testing.
Carsten Aulbach, Head SAP/HCM, Institut Straumann AG
The solution
Straumann selected Query Manager to improve its SAP HR reporting and data quality. With Query Manager, they can generate automated SAP HR reports and check data quality, and run complex queries. They can also send automated reports, punctually and securely, to predefined groups of recipients.
Manual, time-consuming work is also minimised. In the past, there were often errors in the currency (such as EUR instead of CHF), and it took minutes per report to find the missing data records. With Query Manager, Straumann can automatically and proactively check for inaccuracies before the incorrect data lead to problems and errors in interfaces or reports.
The outcome
Straumann now uses Query Manager to provide data as a service. Every Monday morning at 08:00, it automatically sends reports for review to the HR Business Partner and Manager. The group has benefited from a significant improvement in data quality and consistency.
HR and managers are also provided with a variety of reports via Fiori as a self-service.
Industry: Healthcare
Solution: Query Manager
About Straumann
The Straumann Group has its headquarters in Basel, Switzerland, and specialises in aesthetic dentistry. With more than 7,000 employees worldwide, the group develops, manufactures and supplies dental implants, instruments, biomaterials, CADCAM prosthetics, digital equipment, software and soft aligners. These products are used in replacement, restorative, orthodontic and preventative dentistry. The group is recognised as a leading innovator and collaborates with universities, clinics, research institutes and others to enhance the standards of patient care. Its products, solutions and services are available in more than 100 countries.
Request a Query Manager Demo
Experience easy, powerful SAP, SuccessFactors and Payroll reporting for yourself
Learn more about how we helped Straumann
Download PDFRead how other companies succeeded with EPI-USE Labs
Similar stories you might want to read:
Warburtons SAP HCM Reports: Query Manager is the best thing since sliced bread
Securely access and distribute all SAP HCM reports quickly across the business
SAP HCM Reporting soars at Zürich Airport
“Query Manager should be, in my opinion, part of the standard SAP HR solution.” – Anton Mayr, Head of Payroll, Zürich Ai...
Dorset County streamlines their HCM processes
"We have been very happy with Document Builder; it was a worthwhile investment for us..."