Difficulty getting Audit Data, As-of-Reporting or just basic HCM analysis?

about us page title image

What Is Included?

  • GHR Audit Data
    GHR Audit Data
    Get data out of GHR that would otherwise only be accessible via Infor Spreadsheet Designer
  • As-of-Date Reporting
    As-of-Date Reporting
    Produce the reports the senior level executive desire most in minutes instead of weeks
  • Refreshed on your schedule
    Refreshed on your schedule
    Cut down your time to delivery to days not months!
  • Custom Defined Measures
    Custom Defined Measures
    Choose the measures that are unique to your organization, defined at install.

HCM Reporting Data Mart & Analytics has all of this and more!

Most of us in the Infor community know that ‘as of date’ reporting for Infor HR is constantly requested by senior management and difficult to produce. There is no simple way using Crystal Reports or any other reporting tool to create reports that reflect the value of a piece of data at a given point in time, not its current value. For example, a report listing employees and their employee status as of a given date, or turnover and head count trending by month, quarter and year. With Dashboard Gear’s cost effective solution, HR Management Dashboards with drill down capabilities are relatively easy to create.

Reporting & Analysis Dimensions

Heading text

  • Age

  • Tenure

  • Positions

  • User Fields

  • Pay Periods

  • Work States

  • EEO Classes

  • Organization

  • GL Attributes

  • Marital Status

  • Able / Disabled

  • Employee Status

  • GL Account Codes

  • Employee Listing

  • Performance Scores

  • Action Reason Codes

  • Job Codes / Classes

  • Supervisor Structure

  • Head count

  • Turnover by Period

  • New Hires

  • Compensation

  • Company Deductions

  • FTE Counts

  • Turnover Rolling Average

  • Promotions

  • Employee Deductions

  • Additional Custom Measures (at setup)

A complete HCM Reporting Data Layer Solution

Dashboard Gear empowers your leadership by delivering relevant and timely HCM data, allowing for better informed decisions.

Icons_05
Icons_07
Icons_06
Connect to our data layer with any reporting tool you desire. SQL Server Reporting Services, Crystal Reports, Tableau, Cognos, Infor AppStudio, Microsoft Excel. with Dashboard Gear reporting data mart & analytics you have flexibility and scalability of your reporting environment.

Unlock the Data in Infor Talent Management

Branded icons-05

If you have tried to do audit reporting or reporting on encoded data from Infor Global Human Resources (GHR) or any of the other Infor Talent Management applications, you know how hard it can be to retrieve the data out. 


Much of the most useful information such as change history and employee demographical information is either stored in large binary fields that cannot be easily extrapolated by standard reporting methods. Or, if you are just trying to understand the relationship between BusinessClasses and the database tables, the limited documentation and obscurity of relationships can lead to very extended development timelines for your reports.


With the Dashboard Gear HR/PR/BN Infor Data Mart & Analytics you have all this information at your fingertips. Build your audit report in minutes instead of weeks and spend your time making it look beautiful or adding more robust features like charting or just take the time you saved and go home early!

System Requirements

dashboard gears Icons-08

The system works with Infor HCM 8.x, 9.x or 10.x systems.  The Data Mart & Analytics solution requires a Microsoft SQL Server 2008, 2008r2, 2012 or 2014 system with ODBC/OLEDB connectivity to the source Infor tables. 

Optionally, if Microsoft Analysis Services Cubes are desired the requirements of the reporting solution must be met.  In addition, Microsoft Analysis Services must be installed and a Local OLAP Administrator user must be available to create Analysis Databases and Cubes