Query Manager allows you to get your data your way by standardising and simplifying your HR and payroll reporting allowing for a reduction in both costs and complexity. The ready-to-use content and shared intelligence of the online community forums are immensely valuable and users benefit from the best in the business.
Query Manager is crammed with a wealth of in-built domain knowledge. It comes with ready-to-use reports but also enables you to create custom Queries in minutes and combine different data sets such as payroll, master data, organisational management data and configuration data into one report.
The design of Query Manager has been simplified and enhanced so that report creation and distribution is available to a larger audience of users. Through streamlined navigation and user-friendly functions, users can easily execute pre-delivered content, create new content and add additional data sources. Distribution is at your discretion – you’re in control.
In addition to extraordinary capabilities, Query Manager is ‘future-proof’. It is available for use in any of the possible landscape models including on-premise, hybrid and cloud. The solution grows with you, adapts to your needs and style.
Query Manager also includes a live interactive component called Client Central wherein users can participate in an online interactive community, share ideas, download or upload reports, experiences and knowledge, all of which combine to optimise your use of this amazing product. You enjoy unmatched control and get your data, your way.
The data in HCM is stored in multiple modules (Personnel Administration, Payroll, Organizational Management, Time, etc.) that add complexity to reporting.
Query Manager solves the challenge of having to go to multiple places to get the data you need.
The landing page provides a central control point for all Queries. You manage reporting from one place. Access includes Online Queries in Client Central that you can download as you wish. It’s a good idea to browse through the content to see if there is already a report that meets your needs. If there is one, you can use it as it is or modify it as you wish – of course, you can also create one from scratch and there are many ways to create a new Query. All Queries are grouped into a tree structure that is intuitive and flexible, so you can organise it to suit your needs. It also means that selection is faster.
A Roadmap leads you through the Query creation process, a simple search function enables fast field search and filtering and you will find the automated process for querying Organisational and Planning data a great help in streamlining it.
Query Manager has a new formula builder that brings the familiarity of Excel-like formulas to calculate and manipulate values. Just click on ‘Help’ and you’ll see how the formulas work. The product opens the reporting field more than ever by being able to report on much more than HCM. Some examples include SAP configuration tables, SAP Financial tables such as Vendor Master and GL account (more content is coming so watch this space), and any customised development tables. You get your data, your way.
You are able to display data in rows or columns, expanding your output and formatting options.
You can also include graphical indicators, modify selection screens and customise the output to transform your data into the exact report you need.
The ability to easily include hierarchical organisational data which is often challenging in traditional SAP HCM is made easy in Query Manager.
Additionally, you have the choice of many output formats including ALV, XML, CSV, XLS and PDF as well as on-screen output options. You get your data, your way.
Security is top priority and Query Manager respects existing SAP authorisations. In addition, complete control is at your fingertips so you can password-protect reports and also set permissions for PDF results as to who may print, or copy and paste, and much more. It is also possible to schedule Queries to run at recurring intervals, for instance, you may wish to communicate audit and compliance results daily.
The ready-to-use content and shared intelligence of the online community forum are immensely valuable and users benefit from the best in the business.
HR agility is massively improved. Crucially, this reporting solution is “future-proof” – your reporting capabilities will grow with your requirements and demands, not only in the HCM space by accessing SuccessFactors™ data, but for other SAP modules and other external data sources.
Rapid access to accurate information means faster, better informed business decisions. The earlier incarnation of the product has had a profound effect on many organisations and this version takes everything further. Take a look at some of the success stories and videos on this site for confirmation. It’s also a good idea to become acquainted with our active User Group programmes around the world and our ongoing webinar sessions.
With the new Query Manager Fiori web-enabled app, users can easily run any Query Manager 4 report using their desktop or tablet browser. The app allows a user not only run a report but also create insightful charts and view the results of all their previous results.
• For quick navigation the user can view a list of the latest Query (report) results available and go directly to the output.
• The same ALV grid output view is available with our custom built SAPUI5 ALV table. Important or latest results can be 'pinned' for quick access.
• The result of a report can be used to create great looking charts for a Query.
• Charts can visualise aggregated data from the result-set to provide additional insight into the results.
• The Chart Builder enables the user to easily create different charts for a Query with basic guidance.
The Query Manager online community is an excellent discussion and knowledge-sharing platform. You can receive news and updates concerning Query Manager, access videos, demos, tips and tricks, and learn of upcoming events such as webinars on the calendar. It’s the perfect setting to make suggestions for enhancements and perhaps share a few of your own Queries.
The online community facilitates:
• Ticket logging and tracking
• Loading of suggestions for enhancements to the solution
• Downloading, and in future, purchasing additional content
• Uploading your own content
• Registering for giveaways and competitions
All in all, you have a vibrant means of active support and a large repository of Queries and related information to draw on at any time.