FAQs: Query Manager and Document Builder

SAP processes can be complex and can require transports (Development to Quality Assurance to Production) and periodic updates. Standard SAP Query solution functionality has not been updated for over 15 years, which brings additional problems. The changing landscape, such as moving to the cloud with SAP SuccessFactors or migrating to S/4HANA, can make your reporting landscape even more complex.

With Query Manager™ from EPI-USE Labs, a simple user interface puts reports at your fingertips. You are up and running with the solution immediately; it is 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.

Query Manager™ from EPI-USE Labs, the powerful, SAP®-certified solution, enables you to report across your SAP and SAP SuccessFactors landscape. It enables you to access and analyze accurate, real-time data easily. It also accesses your reports directly in Excel and dashboarding tools, and even generates professional documents.

Historically, people have thought of Query Manager as just an operational type reporting tool. But it’s much more than that now. Lane Small, Product Manager of Query Manager with EPI-USE Labs, notes that the exciting thing about Query Manager is that it solves multiple problems for you. It can solve your operational reporting, document generation and distribution, and it can also now solve your analytics problems. It exposes your data and lets you consume that in your analytics platform of choice. You don't need technical expertise or to know the underlying architecture of these complex systems to get your data output. We have simplified this so the everyday functional user is able to create and use the data any way they need it.

You can now report from Employee Central data, your payroll data, and you can also add in your time data from WorkForce Software. Query Manager from EPI-USE Labs enables you to report on all of that, find any exceptions, and also do consolidated reporting across all three different platforms.

Query Manager from EPI-USE Labs 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-premises SAP and SAP SuccessFactors, it gives you one solution for all your reporting needs. It's a comprehensive solution that will journey with you to the cloud, from SAP HR and Payroll and SAP SuccessFactors Hybrid to SAP SuccessFactors Employee Central Payroll.

Yes, Query Manager is certified by SAP for 'Integration with RISE with SAP S/4HANA Cloud'.

Whether you migrated from on-premises SAP Payroll, or simply deployed SAP SuccessFactors Employee Central Payroll, you'll need to report on your Payroll data. EPI-USE Labs’ Query Manager offers:

• Live reporting for Payroll data: on-premises Payroll and SAP SuccessFactors Employee Central Payroll
• The ability to combine data from Employee Central and Employee Central Payroll in a single report
• Live integration with visualization tools such as SAP Analytics Cloud and Microsoft Power BI.

Additionally, Query Manager is both certified by SAP S/4HANA and listed on the SAP SuccessFactors Employee Central Payroll Approved List for live Payroll reporting.

SAP SuccessFactors Employee Central Payroll data and regular SAP S/4HANA Payroll data is not yet available within People Analytics. If you wish to report on data that is unavailable today, or not scheduled for inclusion – like Payroll reporting or on-premises HCM data – you can use Query Manager.

One of the challenges faced by SAP HCM customers is that multiple tools are required to report on critical HR and Payroll data, which is often collected and consolidated offline in an application like Microsoft Excel®, Access® or data warehouses. This process is time-consuming, increases the risk of errors, and introduces security and data integrity risks since the data is extracted and manipulated outside of your SAP system.

Query Manager addresses this by enabling you to connect to multiple sources to get the data you need.

Query Manager saves you using multiple sources to get the data you need. Examples of real-time data sources available include: SAP SuccessFactors data, SAP HCM master data, Payroll (including de-clustered Payroll results), Payroll Postings, Benefits, Time Management and CATS, system configuration tables, custom Z tables, and WorkForce Software data.

With Query Manager, reporting on data from both systems at the same time is easy:

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

As an offline data repository, SAP Datasphere only stores aggregated data and doesn't include real-time information. It usually does not include any transactional or operational data, and has minimal Payroll data.

To overcome this, Query Manager enables you to create powerful reports, regardless of your HCM deployment. We even can use Query Manager as a solution to send your Payroll data to SAP Datasphere.

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

You can achieve this by using the specific functionality designed for EPI-USE Labs Query Manager:

• with the Query Manager SAP SuccessFactors Integration Add-On, you can access your SAP SuccessFactors data as a data source so it can be combined with data in SAP
• with the Query Manager Analytics Connector Add-on, you can use your reports to send the results via OData to dashboarding solutions of your choosing
• using Document Builder, you can generate richly-formatted letters, documents, reports and visualizations automatically, making it easy to automate the distribution of remuneration letters, contracts or pre-populated forms. You can even enable Docusign to have them electronically sent and signed.
• with the Microsoft Excel Add-on, you can refresh, analyze, share, and present your critical SAP HCM or SuccessFactors data on-demand in Microsoft Excel with the click of a button.

With Query Manager™ from EPI-USE Labs, reporting on data from SAP and SAP SuccessFactors at the same time is seamless. You can access your SAP SuccessFactors data via the Query Manager SAP SuccessFactors Integration Add-on, where it is available as a data source that can be combined with data in SAP. What makes this particular integration unique is that not only is it using live data, but the data has also been curated. The raw unstructured generic SAP SuccessFactors data that is exposed via OData is transformed into user-friendly categories and descriptive text fields, making it easy for users to understand what the data is, and report on it accordingly.

The Query Manager SAP SuccessFactors Integration Add-on provides a mechanism that:

• reads data from SAP and SAP SuccessFactors using OData
• remains real-time and on-demand with no duplication of data
• ensures SAP SuccessFactors data is available as a data source in Query Manager, so it can be combined with any data in SAP.

You can quickly produce and analyze SAP HCM reports with the power of Query Manager and the flexibility of Microsoft Excel. With the Query Manager Microsoft Excel Add-on, you can simply click a button to refresh your spreadsheet instantly with dynamic, live data from SAP. 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 just click a button to refresh your spreadsheet instantly with dynamic data from SAP. This functionality allows you to automate your Excel reports, eliminating the process of uploading and downloading data between systems.

To integrate with your analytics solution, Query Manager can serve as an engine for feeding any data available (on-premises SAP data, including Payroll, Time and Configuration, and SAP SuccessFactors and SAP SuccessFactors Employee Central Payroll data) to additional services for dynamic use via the Query Manager Analytics Connector Add-on. Once this has been configured, there is no technical expertise needed to make a report available to your analytics solution.

The Query Manager Fiori Add-on allows you to access your reports from anywhere – you do not have to be logged into a computer with SAP GUI installed. You can run and process reports from web browsers, mobile devices, self-service portals, or even from within SAP SuccessFactors Employee Central using Query Manager. The Fiori Add-on allows you to create charts for additional interaction, drilldown, and analysis, allowing you to visualize your data and transform it into a coherent and meaningful presentation whether you are creating an executive dashboard or monthly employee productivity reports.

You can build professional-looking documents easily with the Document Builder add-on for Query Manager, which features a rich visual designer and intuitive user interface. It enables you to visualize your data with a wide set of controls, define your document structure precisely, and create impressive designs using design-time aids. You can add eye-catching elements with background images, watermarks, dynamic tables and charts, then preview your design instantly as an Adobe PDF document.