It can be challenging getting easy access to – and reporting on – your highly-sensitive SAP and SuccessFactors HCM/HXM 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 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:
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.
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.
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.
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.
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.
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.
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.
Query Manager includes our innovative solution, Document Builder. It helps you generate richly-formatted letters, documents, reports and visualizations ...
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.
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.
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.
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.
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 ...
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.
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 ...
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.
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:
learn more Available on the SAP Store Integration monitoring
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.
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.
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.
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.
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:
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.
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
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.