Work Time Report In FAB - Employee Projections Grid

The Employee Projections - Annual Report grid allows users to view actual work time to date for the current fiscal year, or actual work time for previous years.  

Employee Projections – Annual Report Grid – View Actual Work Time

Set Scenario from “Working Plan” to “Incurred Actuals”

Set Account Filter to “Level 0” via Subset (view your employees on any key)

Set Employee Filter to your group – Lab / Div/ Program via Hierarchy

Set PayPeriod Expense Filter to the fiscal year

Set Employee Plan to Actual from “EmpProjectionMeasures” to “Hours Percent” AND “Pct on Key” via Hierarchy

Set Object Employee from “TotalLoadedSalary_subset” to “Total Salaries-Worked” via Hierarchy – SAVE and NAME

SAVE Dimension Filter with a New Name

 

This allows you to see your employee’s Work Time to date as well as the Percent on Key which shows the % of planned hours for the year that have been worked to date. 

NOTE – this will show any key, including keys with overtime hours.