Simplify and streamline SAP HCM and Payroll reporting Query Manager
Query Manager

: the powerful, SAP-certified reporting solution for your HR and Payroll

 

SAP HR & PAYROLL  SAP SUCCESSFACTORS HYBRID  Live Payroll Reporting  Query Manager Add-ons

250+ ready-to-use pre-delivered reports

250+ ready-to-use pre-delivered reports

13,000+ data sources delivered

13,000+ data sources delivered

80% reduction in report creation time

80% reduction in report creation time

Easy access to reports from all devices

Easy access to reports from all devices

Simple drag-and-drop interface

Simple drag-and-drop interface

Loading

query managerSAP Certified integration with SAP S/4Hana

It can be challenging getting easy access to – and reporting on – your highly-sensitive SAP® and SAP SuccessFactors® HCM and Payroll data. Query Manager™ is a powerful solution that enables you to create custom reports, send automated communications, push content to analytics products (like Power BI or Tableau) and integrate with Microsoft Excel. By combining data from On-premise SAP and SuccessFactors, Query Manager gives you one solution for all your SAP reporting needs. It’s a comprehensive solution that will journey with you to the cloud, from SAP HR & Payroll and SAP SuccessFactors Hybrid to Employee Central Payroll.

The Query Manager Add-on solutions can also help you achieve maximum ROI for your investment, both on-premise and in SAP SuccessFactors. Query Manager with Document Builder™ is certified by SAP for ‘Integration with SAP S/4HANA®’.

 HOW DOES IT WORK?    Request Demo      DISCOVER THE HCM PRODUCTIVITY SUITE

Extract info from your SAP HR & Payroll data

How do you extract accurate, meaningful and real-time information from all of your SAP HCM and Payroll data? Query Manager™ is a powerful, flexible, easy-to-use solution that solves your reporting challenges. The brilliance of Query Manager is that it empowers you to:

  • Access all your data from a single solution in SAP easily
  • Create your own professional reports and documents without relying on technical resources
  • Work with your SAP HCM data on-demand in Microsoft Excel.

Query Manager has access to virtually any data source, although we deliver content for HCM, Payroll and SuccessFactors Hybrid. Additional data sources which may be added include SAP S/4HANA Finance, as many of our clients have successfully done.


The SAP HCM reporting challenge

Why is reporting the biggest challenge for SAP HR and Payroll customers, and how does Query Manager solve this?

  • Multiple tools to create reports
  • Reliance on IT
  • SAP Business Warehouse (BW)

Challenge: You need multiple tools to create reports

One of the challenges faced by SAP HCM customers is that multiple tools (Ad Hoc Query, SE16, Custom ABAP, Wage Type Reporter and others) are required to report on critical HR and Payroll data. This data is often collected via these multiple tools and consolidated offline in an application like Microsoft Excel®, Access® or SAP Business Warehouse (BW). The process is time-consuming and increases the risk of errors. It also introduces security and data integrity risks since the data is extracted and manipulated outside of your SAP system.

Solution: Access to all the data you need via a single solution

Query Manager saves you using multiple sources to get the data you need. Examples of real-time data sources available include: SAP Personnel Administration, Payroll (including de-clustered Payroll results), Benefits, Time Management and CATS, Payroll Postings, Organizational Management, On-Premise Talent modules including E-Learning and Performance Management, system configuration and SAP SuccessFactors data.

Challenge: You have to rely on IT

Users of existing SAP reporting solutions often rely on trained IT resources to create or run their reports. The processes can be complex and can require transports (Development to Quality Assurance to Production) and periodic updates. Standard SAP Query solution functionality hasn’t been updated for over 15 years, which brings additional problems. The changing landscape, including the acquisition of SAP SuccessFactors®, can make your reporting landscape even more complex.

Solution: A simple user interface puts reports at your fingertips

You are up and running with the solution immediately - it’s just an SAP transport to install. You can use over 250 pre-delivered reports immediately, search the online community for existing reports, or easily build your own reports. Query Manager gives you control over what you want to see, the report appearance, and how you distribute the output.

Challenge: Your critical data is not available in SAP Business Warehouse (BW)

As an offline data repository, BW only stores aggregated data and doesn’t include real-time information. It usually does not include any transactional or operational data, and the Payroll InfoCube only allows for monthly results.

Solution: All this - and so much more

Query Manager enables you to create powerful reports, regardless of your HCM deployment. It is integrated with SAP SuccessFactors for On-premise SAP and hybrid SAP SuccessFactors reporting. It also allows you to add your own data sources inside SAP or your own external non-SAP data source, perform calculations on your data, create charts via the Fiori app, produce amazing outputs via Document Builder, and schedule and distribute reports automatically.

  Learn more

Query Manager benefits for SAP HR & Payroll

Create your own professional reports and documents

Create your own professional reports and documents

Query Manager includes our innovative solution, Document Builder. It helps you generate richly-formatted letters, documents, reports and visualizations automatically. Sending out documents – such as remuneration letters, contracts or pre-populated forms – is easy, and distribution can be automated....

Query Manager includes our innovative solution, Document Builder. It helps you generate richly-formatted letters, documents, reports and visualizations automatically. Sending out documents –  such as remuneration letters, contracts or pre-populated forms –  is easy, and distribution can be automated. Include richly-formatted text, images, background images, watermarks, dynamic tables and charts (bar, pie, line, scatter plot). Simply design your document, drag the relevant fields onto the page and send – it’s that easy.

Read more
Build your own formulas leveraging Excel-like functions

Build your own formulas leveraging Excel-like functions

Query Manager has a Formula Builder incorporating thousands of commands and combinations of commands, allowing you to report SAP data exactly as you want. It supports most syntax and function...

Query Manager has a Formula Builder incorporating thousands of commands and combinations of commands, allowing you to report SAP data exactly as you want. It supports most syntax and function equivalents in Excel, with some additional features for an enhanced user experience.

Read more
Work in and share your data via Microsoft Excel

Work in and share your data via Microsoft Excel

With Query Manager’s Microsoft Excel Add-on, you can refresh, analyze, share, and present your critical SAP HCM data on-demand in Microsoft Excel. What is unique about this web app is that once you...

With Query Manager’s Microsoft Excel Add-on, you can refresh, analyze, share, and present your critical SAP HCM data on-demand in Microsoft Excel. What is unique about this web app is that once you have built an Excel worksheet with all the formatting and formulas that you need, you can simply click a button to refresh your spreadsheet with live data from SAP.  The Microsoft Excel Add-on works with Excel for Mac, Windows and the Web.

Read more
Virtually any data source is available

Virtually any data source is available

Virtually any data source is available in Query Manager. Functional samples with delivered content include Personnel Administration, Organizational Management, Payroll and Time clusters, Benefits,...

Virtually any data source is available in Query Manager. Functional samples with delivered content include Personnel Administration, Organizational Management, Payroll and Time clusters, Benefits, Configuration Data, On-premise Talent Solutions and Financial Postings. You can also make other types of data sources available, including custom tables, server input files, non-HCM data and text files.

Read more
Create reports easily with pre-built content

Create reports easily with pre-built content

Speed up your reporting capabilities with our pre-built, easy-to-use reporting catalog that includes reports for each application area in SAP HCM. With streamlined navigation and user-friendly functions, you can execute pre-delivered...

Speed up your reporting capabilities with our pre-built, easy-to-use reporting catalog that includes reports for each application area in SAP HCM. With streamlined navigation and user-friendly functions, you can execute pre-delivered content, create new content and add additional data sources with ease. You can also include graphical indicators, modify selection screens and customize output to transform your data into the exact report you need.

Read more
Integrated with SAP Analytics Cloud (SAC)

Integrated with SAP Analytics Cloud (SAC)

SAP Analytics Cloud is the future for reporting and analytics in SAP. As shown in the image from SAP Analytics Cloud’s official list of data sources, Query Manager is specified as the Partner to provide SAP On-Premise data, SAP...

SAP Analytics Cloud is the future for reporting and analytics in SAP. As shown in the image from SAP Analytics Cloud’s official list of data sources, Query Manager is specified as the Partner to provide SAP On-Premise data, SAP Payroll data and Configuration data.

Read more

I don’t know why anyone would not have Query Manager; the benefits and the value-add far outweigh the costs. It pays for itself in a couple of months and empowers the HR team.

Michael Gleeson, Amey

SAP SuccessFactors Hybrid

As you journey from On-premise SAP to SuccessFactors, you may find yourself in a Hybrid scenario, using some SAP and some SuccessFactors modules at the same time. With Query Manager, reporting on data from both systems at the same time is easy:

  • SuccessFactors is simply another data source available to you in Query Manager
  • Data is read in real time, and there is no duplication of the data
  • Data is managed via the strict SAP and SuccessFactors’ security protocols

learn more     Available on the SAP Store    Integration monitoring

SAP SuccessFactors Hybrid Benefits


Create reports with data from both systems

Compare legacy HR and Payroll data

You may have started your cloud journey with a Talent solution from SuccessFactors, while still using your On-premise SAP HR and Payroll. Query Manager makes it easy for you to access both, allowing you to report on employee data from the SAP database and recruitment data in SuccessFactors.

Read blog | Watch webinar

Compare legacy HR and Payroll data

Create reports with data from both systems

When data is moved from one system to another, you need to ensure that it is accurate and consistent, without discrepancies. With Query Manager, you can perform a detailed comparison of the data between the two systems – including any mapping rules – in real time, to identify any mismatches quickly and easily.

Read blog | Watch webinar

Check data replication errors

Check data replication errors4

Data replication means making sure you have the correct data in the right systems. It’s the process of storing data in more than one place to improve its availability, and often involves copying data from one place to another. Query Manager gives you confidence in the data replication process and allows you to audit for consistency.

Read blog | Watch webinar

Assist with system updates & Support Pack Testing

Assist with system updates & Support Pack Testing2

Applying each Support Pack potentially introduces changes to a system’s configuration and processing, that then requires reviewing. You need to run before and after reports that flag any changes to records – configuration, Master data or Payroll results – following a system update or Support Pack application. Query Manager solves that challenge.

Read blog | Watch webinar

Are you using SAP SuccessFactors Employee Central Payroll?

Approximately 700 customers are currently licensed for SAP SuccessFactors Employee Central Payroll. If you’re one of them, read on!
Whether you migrated from On-Premise SAP Payroll or simply deployed Employee Central Payroll, you’ll need to report on your Payroll data.
Query Manager offers:

  • Live reporting for Payroll data – On-Premise Payroll and SuccessFactors Employee Central Payroll
  • Integration with Payroll Control Center
  • The only solution both certified by SAP S/4HANA and listed on the ECP Whitelist for live Payroll reporting

employee cost


Real-time Employee Central Payroll reporting is available via Query Manager, the only SAP S/4HANA-certified solution

According to the SAP SuccessFactors Roadmap, the inclusion of some Employee Central Payroll data is scheduled, but not yet available within People Analytics. If you wish to report on data that is unavailable today, or not scheduled for inclusion at release – like Payroll reporting or On-premise HCM data – you can continue to use Query Manager.  

Read blog | Watch webinar

With Query Manager, it’s like Steve Jobs said: ‘It just works’. It does exactly what you want it to do. It is a reporting tool, but it has additional functionality that standard SAP reporting tools don’t have.

Gary Midgely, the BBC

Solve typical day-to-day HR challenges with Query Manager

Do I need to use multiple tools and MS Excel to create HCM or Payroll reports?

Download ebook

How can I save costs on SAP HCM and Payroll Reporting?

Read Blog

Do I have to rely on ABAP or IT resources for my HR and Payroll reports?

READ BLOG

How can I validate data replication between SAP SuccessFactors and SAP?

READ BLOG

Is there an easier way to do reporting than SAP Wage Type Reporter?

READ BLOG

How can I password protect and encrypt my SAP HCM/HR reports automatically?

READ BLOG

Is my SAP Payroll too complex to move?

READ BLOG

Can I report on data from SAP and SuccessFactors at the same time?

READ BLOG

Is my software allowed to run on SAP SuccessFactors Employee Central Payroll?

READ BLOG

Designed for you by industry experts

Danielle Larocca, our Senior Vice President of HCM Solutions, has been working in the SAP HCM space for over 25 years. A distinguished SAP Mentor and SuccessFactors Confidant and featured speaker at international conferences on SAP, SuccessFactors and HCM, Danielle has authored four best-selling books on SAP, and served as the Technical Editor for the SAP Professional Journal. She is also an expert in the SAPInsider Community.

Request Demo

Explore how other clients successfully solved their SAP and SuccessFactors HCM reporting challenges

BBC Benefit

The BBC benefits from quality test data and automated SAP HCM reporting

Query Manager, Document Builder and Data Sync Manager help the British Broadcasting Corporation (BBC) to save time and be more efficient.

Learn more

Amey SAP HCM reporting

Query Manager makes light work of Amey’s SAP HCM reporting

Query Manager brings Amey the flexibility to manage all HR reporting in-house with quick and easy automated processes.


Learn more

First class solution for University of Cape Town

First-class solution for the University of Cape Town during COVID-19

"When we discovered Query Manager with Document Builder, we realised that we would solve not just one problem but a whole lot more."

Learn more