DataBroker™

HR experts, business customers, and executives are all equally frustrated by the challenges associated with getting the reports to satisfy their ever-changing business needs. Despite having a more powerful platform than ever in SAP and brilliant IT professionals, reporting remains the most common complaint we hear today due to IT department backlog and the continual shifting of business data requirements. We have developed a simple, yet powerful report-generating platform called DataBroker to overcome these challenges.

As pioneers in the self-services arena, we recognize the advantages of providing people most familiar with the problem with tools to help them solve it. Following this model, DataBroker allows human resource experts without ABAP or programming knowledge to create and modify complex reports through a menu-driven criteria selection process.

DataBroker resides inside of SAP, which brings many benefits:

• Produces standard SAP reports. Reports made with DataBroker are standard SAP reports that can be added to the report tree for all users to access.
• No hidden costs. Because its build in SAP core technologies so there’s no new hardware, software, desktop updates or anything that would increase you support costs.
• Auditor approved. Leverages the existing SOX controls and compliance processes in place now and enhances them with new controls.
• IT standards compliance. DataBroker leverages existing IT standards giving your IT professionals the assurance that nothing will be accidentally broken.

Latest Features

In the newest version of Data Broker, users can now create reports using all of the information within each pay period's result as a single holistic dataset. For example, as well as being able to report on pay check values such as hours, rate or amount, users can now report on the allocations of those values across organizational units, cost centers, tax authorities, etc. These capabilities are game changing because they instantly make available reports for financial cost allocations and analysis, tax reporting and organization or managerial budgeting tracking. In addition, the newest version of Data Broker also includes reporting on an employee's organizational management and person development Infotypes. This allows HR users to create reports such as job and position match ups with an employee's HR data or report on the employee's qualifications and skills.

New reports

› Payroll Headcount › Payroll cost allocation by Cost Center › Payroll cost allocation by Tax Authority › Payroll cost allocation by Org Unit › Employee Position Details

› Employee Qualification list › Employee Job Details › Employee Position and HR Master Data Matchup › Employee Position Salary matchup Audit

Pre-developed Reports available with DataBroker:

HR Metrics
› Current Headcount › Current Headcount FTE › Current Headcount EEO Demographics › Headcount Trend (Weekly, Monthly, Annually) › Headcount FTE Trend (Weekly, Monthly, Annually) › Headcount EEO Demographic Trend (Weekly, Monthly, Annually)		› Hiring Trend (Weekly, Monthly, Annually) › Termination Trend (Weekly, Monthly, Annually) › Promotion Trend (Weekly, Monthly, Annually) › LOA Trend (Weekly, Monthly, Annually) › Compensation Trend (Weekly, Monthly, Annually)
HR Reports
› New Hire Report › Turnover Report › Promotion Report › LOA Report › Date Specification (Infotype 41) › Employee with EEO Job and Position Info Report › Employee EEO Demographic with Paycheck Report		› HR Master Data Change report (Current period & Retroactive periods) › Employee Supervisor/Chief › Employer Costs by Chief › Total Planned Employee Compensation Report › Total Actual Employee Compensation Report › Employee Qualification list
Payroll
› HR Master Data & Paycheck Reconciliation › Gross-to-Net payroll register › Union reporting › Deduction & Arrears Report › Employee Master Data with Pay Results (RT, CRT, TAX, TCRT, ARREARS) Report › Garnishment Setup & Payroll Deduction Reconciliation		› Vacation Liability Report › FICA Reconciliation › Employee Tax Payment Auditor › Payroll cost allocation by Cost Center › Payroll cost allocation by Tax Authority › Payroll cost allocation by Org Unit › Payroll Headcount (payroll data based)
Benefits
› Benefit Census › Benefit plan enrollment cost & payroll deduction Reconciliation › FSA & payroll deduction Reconciliation › Benefit plan Opt-out & Un-enrolled Reconciliation › 401K Match Report › 401K Discrimination Testing Report		› Benefit Participation (single row per employee) Report › LOA with Employee Pay and Arrears Report › Employer Benefit Costs (Combined current period, MTD, QTD & YTD) Report › Benefit Eligibility (Actual Hours/Pay) Audit › Dependents Over Age Audit
Time Management
› Perfect attendance Report › Overtime Trend Report (Daily, Weekly, Monthly) › Productive Hours Trend Report (Daily, Weekly, Monthly)		› Paid Leave Trend Report (Daily, Weekly, Monthly) › Unpaid Leave Trend Report (Daily, Weekly, Monthly) › Absence/Attendance Report

Sample Screen Shots

These DataBroker screenshots show the easy-to-use, menu-driven process to create new and modify existing complex SAP HR reports.

Product Brochure

		Product Brochure Download this DataBroker brochure for complete functional and technical product specifications in a graphical format.

 

SAP Product Overview:

• Data Broker product is developed using SAP ABAP and deployed in the customers exist SAP HR environment
• No Customer ABAP development effort required to implement Data Broker
• No Customer ABAP development effort required to create Data Broker reports
• All development objects (ABAP reports and screens, tables, security roles, etc) are delivered via SAP transports
• Reports can be given an SAP Transaction code and added the User’s SAP Easy Access menu Favorites
• No code modifications or copies of SAP objects required to implement
• User ability to run reports for employee and employee data is defined by your current SAP security authorizations
• Access to employee is restricted using the standard SAP authority checks of the PNP logical database report
• Access to each infotype is restricted using the standard SAP function module HR_CHECK_AUTHORITY_INFTY
• Reports data is displayed as SAP ALV grid allowing the full capabilities for sorting, filtering, summing and download to excel or other file formats

SAP Release Requirements:

• Earliest Release: SAP R/3 4.7B
• Latest Release: SAP ECC 6.0, EhP5

Additional Software or Hardware Requirements:

• None

Implementation time

Getting started with Data Broker takes less than one hour to add the product to your SAP environment. With our two hour training course, human resource experts will be ready to start adapting existing reports and building their own new reports.

SAP Product Overview

DataBroker product is developed using SAP ABAP and deployed in the customer’s exist SAP HR environment.