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

SAP HR reports

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 YOUR Query Manager demo     DOWNLOAD SUCCESS STORY

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.


The University of Tennessee

View Success Story


Zürich Airport

View Success Story


Dorset Council

View Success Story