WFM Analytics for Birst

Add timestamp to the work summary start and end dates

Changed the Work Summary Start & End date with Date/Time so that user can see the Date/Time for those fields.

Join Pay Group and Pay Period to Employee History to support better analysis of Employee details by Pay Period.

The Pay Group and Pay Period dimensions were joined to Employee History to allow for better analysis of the Employee details by Pay Period. The Pay Period ID was added to Employee History fact table using the Pay Group ID and Employee History Start Date falling between Pay Period Start and End Date range. Pay Group ID already exists in the fact table.

Convert team hierarchy to team chart

  • Collections: All
  • Dashboards:All
  • Reports: All
  • Filters: All

Replaced the Team Hierarchy dimension with the Team Chart dimension.

When the termination date range is defaulted to year 3000, it cannot be used to filter since Birst does not support long date range to filter records

The Termination Date range in the data is defaulted to year 3000 in the database, which cannot be used to filter since Birst does not support long date range to filter records.

The Termination Date was made NULL for wherever the default date of 3000 and above is used. These changes were made in the Employee History Fact table.

Terminations Dashboard: Add a new Terminations by Length of Service (LOS) report

  • Collection: Employee
  • Dashboard: Terminations Overview

Added the new report named Terminations by LOS.

Add the Override Type filter to the Authorizations dashboard

  • Dashboard: Authorizations Dashboard

Added the Override Type filter to the Authorizations dashboard to improve filtering capability.

Employee Detail Dashboard and drill across

  • Name of Dashboard: Employee Overview Dashboard.
  • Purpose: Added Drill Across function in every dashlet to jump into the Employee Detail Dashboard.
  • Dashlets Affected: Employee by Work Type, Employee by LOS Group, Employees by Age Group, Employees by Job, Employees by Employment Type.
  • Name of Dashboard: Employee Detail Dashboard.
  • Purpose: A new dashboard to show more detail about from Employees Overview Dashboard.