Let's Talk HCM

Shared by our experts

Trying to Compare Query Manager and SAP SuccessFactors Workforce Analytics is like trying to compare Apples and Oranges

Oct 8, 2017 8:04:21 PM

Comparing Apples to Oranges

Query Manager is the leading reporting solution used by thousands of SAP HCM customers around the world every day to solve SAP HCM reporting challenges, including:
1. Reliance on IT to produce reports (using technology like custom-coded ABAP)
2. Multiple solutions/utilities + Excel needed to create reports for various modules
3. Transactional and Payroll data not included in BW

As SAP HCM became more mature, and with the acquisition of SuccessFactors, Query Manager has added functionality that allows users to execute reports via a browser (including mobile devices) and includes the ability to report on data from both SAP and SuccessFactors at the same time.

Some of the most common themes about Query Manager reporting include:

1. No implementation required to install (it’s simply an SAP transport), you can be up and running in minutes
2. All data is live, in real time, and you can include data from virtually any data source*
3. The tool is easy to use and automates the delivery of reports via email, your portal MSS, etc.

Query Manager sounds great, so why is comparing it to the highly regarded SAP SuccessFactors Workforce Analytics like comparing apples to oranges? In this blog, I review three of the main reasons why. 


A SuccessConnect 2017 Recap from SAP Mentor Danielle Larocca

Sep 16, 2017 8:53:28 PM

A Quick SuccessConnect 2017 Recap 

I recently had the opportunity to attend the annual SuccessConnect 2017 event held in Las Vegas. It was reported that there were 3,414 attendees, including 121 customer speakers. This is the first year that the event was sold out in advance and I suspect that is in correlation with the increase in SAP SuccessFactors adoption from existing SAP HCM customers. The published numbers are shown below.


A Quick Look at SAP QuickViewer

Sep 3, 2017 1:08:04 PM

What is the SAP QuickViewer (Transaction Code SQVI)?

SAP comes pre-delivered with a handful of reporting utilities including the query-based reporting utilities, SAP Query and Ad Hoc Query (InfoSet Query). There is also a utility called SAP QuickViewer (Transaction Code SQVI) that is available for quick data retrieval.

Following my last blog - Fixing duplicate line reporting in SAP HCM - I received an inquiry about QuickViewer, so I wanted to share a blog note on it.


Fixing duplicate line reporting in SAP HCM

Aug 13, 2017 12:04:34 PM

Reporting in SAP HCM is never easy

There are multiple tools to choose from, including the Ad Hoc Query and the SAP Query, both accessible via transaction code SQ01. These tools have limited functionality; however they do, in most cases, allow you to report on basic infotype data for employees.

One frustrating result output that you will find with these tools is that sometimes you will see report output that has multiple lines per employee instead of a single line output per employee. There are a couple of different scenarios in which this may occur:


How to better design your HR actions to improve HCM Reporting

Jul 31, 2017 7:10:00 PM

Designing your Employee actions

This blog talks about configuring actions properly in order to improve data and reporting.  The configuration of personnel actions such as hiring, terminations, and organizational assignments in SAP ERP HCM is completely customizable. The SAP-delivered actions can be customized to your company's needs so you can collect necessary data and assign specific employment statuses. The employee data collected during your actions then can be classified with reason codes that will provide you with better employee groupings for reporting. Before you configure new actions, here are three questions to ask:

What data do I need to collect?

  1. What statuses do I want to assign?
  2. What reporting goals do I have related to these actions?

I'll explain why these questions are so important. Then I'll show you how to create your own HR actions.