Business Intelligence

Cognos Analytics: Add new columns to the ENT_DETAIL object in the data model

Three new columns were added to the Leave Management Policies.Entitlement Details namespace in the Standard model. The new columns are:

  • Annual Max
  • Year Start
  • Annual on Max

For more information, see Infor Workforce Management Metadata Model Reference Guide.

Work Adjustment report available in My Reports menu

The Work Adjustment report, which was previously only available in the Payroll Close Wizard, is now available interactively from the My Reports menu in WFM. It is also available as a scheduled report.

For more information, see Infor Workforce Management Standard Reports Guide.

Scheduled Minutes added to the metadata model

Scheduled Minutes was added to the Cognos metadata model in the following locations:

  • WFM Standard > Ad-Hoc Query Layer > Scheduling > Scheduled Shift > Scheduled Minutes.
  • WFM Standard > Ad-Hoc Query Layer > Scheduling MVS > Scheduled Shifts > Scheduled Detail > Employee Scheduled Detail > Scheduled Minutes.
  • WFM Standard > Ad-Hoc Query Layer > Work > Employee Schedule > Scheduled Minutes.
  • WFM Burst > Bursting Layer > Burst Scheduling > Scheduled Shift > Scheduled Minutes.

The WFMStandard and WFMBurst packages have been updated.

For more information, see Infor Workforce Management Metadata Model Reference Guide.

Work Detail comments added to the metadata model

Work Detail comments have been added to the Cognos Analytics metadata model in the WFMStandard package. See WFMStandard > Work > Comments.

For more information, see Infor Workforce Management Metadata Model Reference Guide.

Work Summary comments added to the metadata model

Work Summary comments have been added to the Cognos Analytics metadata model in the WFMStandard package. See WFMStandard > Work Day > Comments.

For more information, see Infor Workforce Management Metadata Model Reference Guide.

WFM Analytics: Overtime Cost Overview dashboard

The Overtime Cost Overview dashboard provides a breakdown of costs by jobs, departments, and general trends.

This dashboard is comprised of the these KPI's and Visualizer Reports:

  • KPI: Actual Cost
  • KPI: Actual Overtime Cost
  • KPI: Overtime Cost Percentage
  • Visualizer: Actual Cost Scant Chart
  • Visualizer: Actual Overtime Cost Percentage Scant Chart
  • Visualizer: Actual Overtime Cost Scant Chart
  • Visualizer: Average Overtime Cost by Employee Work Type
  • Visualizer: Exception Cost Trends
  • Visualizer: Overtime Cost by Job
  • Visualizer: Overtime Cost by Team and Department
  • Visualizer: Overtime Cost by Team and Hour Type
  • Visualizer: Overtime Cost by Time Code

WFM Analytics: Terminations Overview dashboard

The Terminations Overview dashboard provides termination KPI's and metrics across a number of categories including Job, Employment Age Group and Employment Type.

This dashboard is comprised of these KPI's and Visualizer Reports:

  • KPI: Termination
  • KPI: Termination FTE
  • KPI: Turnover Rate by Date Range
  • Visualizer: Length of Service at Termination by Job
  • Visualizer: Terminations by Employee Age Group
  • Visualizer: Terminations by Employment Type
  • Visualizer: Terminations by Job
  • Visualizer: Terminations by LOS Group
  • Visualizer: Terminations by Work Type

WFM Analytics: Absence dashboard

The Absence dashboard provides a broad overview of controlled (planned) versus uncontrolled (unplanned) by pay period.

This dashboard is comprised of these KPI's and Visualizer Reports:

  • KPI: Controlled Absence Percent
  • KPI: Uncontrolled Absence Percent
  • KPI: Work Detail Absence Hours
  • Visualizer: Absence Hours by Time Code
  • Visualizer: Controlled Absence Percent
  • Visualizer: Controlled vs Uncontrolled Absence Hours over Pay Period
  • Visualizer: Planned Absence Percent
  • Visualizer: Planned Absence Percent by Pay Period Scant Chart
  • Visualizer: Total Absence Hours by Pay Period Scant Chart
  • Visualizer: Uncontrolled Absence Percent
  • Visualizer: Unplanned Absence Percent by Pay Period Scant Chart

WFM Analytics: Overtime Hours Overview dashboard

The Overtime Hours Overview dashboard provides a breakdown of overtime hours by a number of categories, for example job and department. The dashboard also indicates overtime hours as a percentage of the total hours.

This dashboard is comprised of these KPI's and Visualizer Reports:

  • KPI: Pct of Total Hours
  • KPI: Total Overtime Hours
  • Visualizer: Overtime Hours by Department
  • Visualizer: Overtime Hours by Job
  • Visualizer: Overtime Hours by Pay Period
  • Visualizer: Overtime Hours by Team