Analyze data in SuccessFactors EC and ECP: An SAP Payroll analyst’s dashboard

July 15, 2021
Written by Paul Lamonica

Paul is a Senior Solutions Architect, responsible for training of all EPI-USE Labs HCM products. He also works on new customer demos and national webinars hosted by EPI-USE Labs.

With many SAP payroll customers moving to the cloud for their HR needs, it has become apparent that differences in Employee Central (EC) data and Employee Central Payroll (ECP) data or on-premise SAP payroll data, are causing payroll analysts additional time-consuming work when trying to determine the out-of-sync conditions between the two systems. While there are existing reporting capabilities in both EC and ECP, each of them on their own do not often satisfy the requirements analysts require. And what’s even worse, the reports are created separately, containing data from their respective systems, which then calls for extra steps by the analysts to marry the reports together to find where data is inconsistent.


This is where a product like EPI-USE Labs’ Query Manager™ can provide payroll analysts with a method to report on both EC and ECP data together within one report. And, the report can easily highlight where data is different between the two systems.

To demonstrate Query Manager’s capabilities, let’s use an example that is most likely one that payroll analysts would find realistic in their data validation routine.

Prior to the next pay cycle to be executed, it’s imperative to check that the following data elements are in sync between EC and ECP:

  • Annual Salary
  • Recurring Payments and Deductions
  • City and State of Residence (for tax calculation purposes)

Here is a report created through Query Manager that has retrieved data from EC and ECP in real time, and has quickly and easily highlighted differences with respect to these three types of payroll-related data:

QM Report

Now that the data has been combined from the two systems and the differences identified, what’s next?

Although creating this report is the crucial first step, we can’t stop here. We need to get answers to the following three questions for the creation of this report to be beneficial:

  • How can the report be available to the payroll analysts who need it?
  • How can the data be refreshed so that the analysts are always looking at current results?
  • How can the results be displayed in different ways, providing the payroll analyst with different views into the results?

EPI-USE Labs has also solved these issues with the use of our Query Manager Analytics Connector, and with a little help from one of the many visualization tools that exist, such as Microsoft’s Power BI, Tableau, or SAP Analytics Cloud. While any of the visualization tools will work with the Query Manager Analytics Connector, in this blog we will be using Microsoft Power BI as our chosen tool.

EPI-USE Labs’ Analytics Connector allows the results of your Query Manager query to be available to the visualization tool, where the data can be turned into a variety of output types that makes the analysis of the data very user-friendly. And maybe one of the most important points of all: the whole process can be automated and scheduled, so there is no manual intervention within the process.

Here is a typical process flow:

  • Schedule the Query Manager query to be run automatically every day at 7:00 a.m. This functionality exists directly within Query Manager. Data has now been combined from EC and ECP, and the discrepancies have been identified.
  • Schedule your Power BI refresh to kick off automatically every day at 7:30 a.m. This is standard functionality with Power BI and is very easy to set up. Power BI now recognizes the most current results obtained from the Query Manager query, using the Query Manager Analytics Connector as the gateway between Power BI and the Query Manager query results.

It’s that simple. Those two easy steps have now allowed the payroll analysts who need to view and resolve the data discrepancies to see the most current results within Power BI. Also, they can see the results in a variety of ways that makes it very easy to know the next steps to take.

Here are just a few of the many ways to display the data differences within Power BI.
First, separate reports can be created that show the discrepancies for each of the payroll-affecting areas being interrogated. Naturally, each of these reports can be downloaded into something like a Microsoft Excel® spreadsheet, if the user prefers to use the data in that way:

Mismatch in annual salary

Mismatch in recurring payment

Mismatch in city

Next, the results can be displayed in a summarized fashion.

The first two reports show the number of differences for each of the areas being checked, while the third report simply shows the total number of employees on the reports, and the number of employees who have at least one discrepancy.

The great part of the detail reports and the summarized reports is that they are showing the discrepancies that exist within the EC and ECP systems using constantly refreshed data. And, the reports were created automatically with no manual intervention.

Recap of mismatches

Whenever the same type of data exists in more than one system, the possibility for data discrepancies can always occur. For years, having automated processes that can report and identify these data differences has always been a challenge. And the distribution and refreshing of those reports with current results has never been a smooth process. But now, with the use of EPI-USE Labs’ Query Manager and Query Manager Analytics Connector, along with the use of one of the many visualization tools, the completely automated process of getting this vital information into the hands of the users who need them has been significantly simplified.


New call-to-action



Explore Popular Tags

Query Manager SAP SuccessFactors SAP HCM reporting HCM Reporting SAP HCM SAP Reporting HCM reporting EPI-USE Labs Payroll Document Builder SAP Analytics Cloud SAP Query SAP SuccessFactors Employee Central Payroll SAP Payroll Microsoft PowerBI Query Manager Analytics Connector SAP HCM Data SAP SuccessFactors People Analytics Payroll reporting SAP SuccessFactors Reporting Human Capital Management (HCM) Payroll Data SAP Payroll data Tableau Variance Monitor people analytics sap query hr Data Sync Manager Employee Central Payroll SAP COVID-19 HCM Productivity Suite HR Journey to SAP SuccessFactors SAP HCM journey reporting solution successfactors ABAP Cloud-based SAP HCM solutions DSM for HCM Employee data GeoClock HXM Move PRISM Pay Recon Query Manager with Document Builder SAP HR Reporting SAP SuccessFactors HCM Journey data validation payroll control center Data Sync Manager for HCM Employee Central GDPR Let's Talk HCM OData SAP Data Warehouse Cloud SAP ERP HCM SAP HCM Analysis SAP HCM On-Premise Solutions SAP HCM On-premise SAP HCM Payroll SAP HXM 2021 SAP On-Premise customers SAP S/4HANA Private Cloud Edition (S/4 PCE) SAP SuccessFactors Roadmaps SAP and SuccessFactors HXM Reporting SAP customers Success Factors SuccessConnect 2019 Successconnect Tax Reporting Transformation without re-implementation certification custom infotype data source DSM Object Sync for SuccessFactors Hybrid Employee Central Payroll Reporting Employee Letters Employee payroll Free HCM Assessment HCM, HR HR Journey HR Service Delivery HR and Payroll data Human Resources Human Resources data Hybrid Reporting SAP and SuccessFactors Hybrid SAP and SuccessFactors Hybrid reporting Hybrid reporting solution Intelligent HR and Payroll Microsoft Excel OData integration OM Object Sync On-Premise Payroll On-Premise Payroll S/HANA Sidecar On-premise reporting PA People Analytics Workforce Planning Personalized documents Protect personal employee data Real-time reporting and document creation Robotic Process Automation framework SAP Data Security SAP HCM/HXM SAP HR SAP Mentors SAP Payroll to the Cloud SAP S/4HANA SAP SuccessFactors Hybrid SAP SuccessFactors Time Management SAP SuccessFactors Time Tracking SAP certified solution SAP data privacy and compliance SAP migration SAPPHIRE 2018 SuccessFactors' Employee Central Payroll The Report Center The Road to People Analytics Time management Workforce Planning ad hoc easy reporter ebook high-speed, low-risk on-premise SAP HCM on-premise SAP data partner roadmap s/4HANA single reporting solution sq01 technology third party ALE STP report ASUG Accessing COVID-19 data Ad Hoc Query American Payroll Association (APA) Analytics Connector Analytics reports Analytics solution Analytics solutions At-risk employees Australian Payroll Australian Tax Office (ATO) Automated analysis and pay run reconciliations Automated reports Automatic HR reports Automation Best practice in BI Bots Business Analytics Business Intelligence COVID-19 statistics COVID-19 vaccinations Certified solutions Check for data replication errors Client Sync Cloud hosting SAP PCE Cloud migrations Company Branding Compare legacy HR and Payroll data Comparing data Configuration Center Copy and mask test data Coronavirus Created timestamp Customer-specific infotypes DSAG Data Privacy Data Replication Data Secure Data Sources Data Sync Manager (DSM) Data Types Data analysis Data privacy regulations Data production support issue solution Description Diversity & Inclusion reporting DocuSign Document Building Dynamic data ECC EPI-USE Labs’ solutions ERP Education sector Electronic Signatures Embedded Analytics Edition Employee Central time Employee Central timesheets Employee NICs Employee communication Employee payment summaries Employee right to privacy Employer NICs Encrypt data FAQ Index Font Guidelines Gender Pay Gap General Data Protection Regulation Governance, Risk Management and Compliance (GRC) Government forms Grid control Grid layout HANA HCM Client Sync™ HCM/HXM/HR Blogs HIPPA HMRC HR Innovations 2019 HR and Payroll Integration HR conference HR documents HR employee reports Historical payroll results Hourly time tracking Human Capital Management Human Resources reports HumanRevolution Hybrid SAP SuccessFactors environment IRS Tax Withholding Estimator Infotype Instance Refresh Instance Sync Instance Syncing Integrated reporting SuccessFactors SAP Intelligent Enterprise Intelligent slicing of payroll data JHUCSSE Knowledge Base (KB) Articles Kronos LabsScript Learning and growth Leave Liability Reporting Legislative compliance Leveraging Fiori Technology Location Managed Payroll Merging and splitting of cells Modified timestamp Move to SuccessFactors Employee Central New York Times News OCHA Organization of the data Owner
+ See More

Get Instant Updates

Leave a Comment: