Reports Dependent on Report Dump

Currently there are a number of reports that rely on Report Dump data.

The following reports rely on Report Dump having been run at least once to populate the TIMEZONE table:

User Roles
Employee Info

The reports listed below require Report Dump to be run after any change to employees’ organization assignments, to populate the ORGANIZATIONDAY table, or, for time entries, schedule import, activity Core component of both schedules and time records in Workforce Management (WFM). When an employee performs any kind of work, activities specify the scheduled work and capture employee adherence to their schedule. tolerance, or activity mapping, to populate the ACTUALEVENTTIMELINE, PLANNEDEVENTTIMELINE, and ADHERENCEEXCEPTION tables:

Adherence Minutes
Adherence Summary
Adherence Numbers By Interval
Adherence Exceptions
all Time-Off reports

Adherence Minutes and Adherence Summary compute daily aggregations on an employee's workday. You supply a date range (local date), and these reports return daily aggregations for all workdays that begin within the specified time range, based on the organizations’ day boundaries.

All the Time-Off reports depend on the ORGANIZATIONDAY table which, as mentioned above, is only populated the first time Report Dump is called. In addition, the following Time-Off reports are dependent on the regularly updated data from Report Dump:

Time Off Allocations Feature in WFM used to manage the forecast and distribution of work across distributed queues. by Time
Absence Hours and Absence Shrinkage for Employee by Time
Absence Hours and Absence Shrinkage for Employee Filter by Employee
Absence Hours and Absence Shrinkage for Employee Filter by Organization
Absence Hours and Absence Shrinkage for Employee Filter by Time

All of the Staffing reports depend on Report Dump to populate one or all of the following tables:

ORGANIZATIONDAY
PLANNEDEVENTTIMELINE
TIMEZONEAM

The reports listed below require Report Dump to be run after any change to employees organization assignment, to populate the ORGANIZATIONDAY table, or time entries to populate the ACTUALEVENTTIMELINE table:

Daily Time Record Summary
Detailed Time Record
Employee Activity Summary
Organization Activity Summary
Daily Activity Summary
Employee Activity Roll Up
Activity Roll Up
Activity Cost

All reports with an employee filter selector run a subset of Report Dump automatically every time a report is run to populate the EMPLOYEEFILTEREMPLOYEE table.

The default setting for the Report Dump Timer is to do a report dump daily at 3 a.m., as a compromise between performance and how up to date the data is. Running Report Dump is very CPU-intensive and increases network traffic. To avoid degrading the performance of the rest of the system, we advise you schedule Report Dump to run only at night, during non-peak hours.

As a result, be aware that regularly scheduled reports that rely on Report Dump are run on the previous day’s data.