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
.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
.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