-
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
Query Manager makes Straumann smile
50 queries per week
An average of
>500 runs per month
Automated
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.
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
Zürich Airport
