Page History

The Ad Hoc Reporting screen enables a user to create completely customizable reports on both performance and quality-related data. The user can specify which reporting metrics to include, in what order they appear, and can apply constraints to limit the data presented. The user also has full control over how data is grouped and totaled.

The Ad Hoc Reporting framework also reports on Utilization and Effectiveness a little differently than the reports in the Performance/-Cost Reports tab. With an Ad Hoc report, you can accurately report on utilization and effectiveness at ALL grouping levels. This is accomplished by factoring in any and all adjustment assignments in parent groupings. In other words, running an ad-hoc report with groupings 1) Employee, 2) Activity will list activities with times in both the "time on standard" and "delay", "indirect", or "break/lunch" columns. This indicates that an employee was in a standard activity and had a delay, indirect, or break/lunch occur WITHIN that activity.

For example, if an employee spends 1 hour in activity "Pick", but 10 minutes of that was actually spent in a delay, the ad-hoc report would display, for "Pick" :
Total Time: 60 mins
Time on Standard: 50 mins
Delay Time: 10 mins
Standard Time: 52 mins
Performance (for "Pick") = (52 / 50) - 1 = +4%

As a result of this, delays and indirects that are adjustments shall no longer be listed in their own activity grouping (as these times will be reported under the parent activities in which they occurred). As such, parent-level indirects will be grouped when grouping by "Activity", and child-level (adjustment) activities will be grouped when grouping by "AdjActivity".

To access the Ad Hoc Reporting screen:

1. Log in to ProTrack Warehouse.
2. Select the Ad Hoc Reporting tab under the Analysis menu. The Ad Hoc

...

1. Reporting screen appears.
   
   

   image
   image Ad Hoc.jpg title Fig.117 Ad Hoc Reporting

   
   Ad Hoc Tab Descriptions

   Tab	Description
   Basic	Displays detailed information about the ad hoc report.
   Group	Contains the filtering and grouping criteria of the ad hoc report.
   Metrics	Displays which metrics will be shown on the ad hoc report.

   ^{Table 16. Ad Hoc Tab Descriptions}
   
   

   Info
   title Info
   ProTrack Warehouse comes preconfigured with all of the previously-available Performance/Cost Reports, but in the Ad-Hoc format. The user may now opt to use either Analysis > Performance/Cost reports module or the new Ad Hoc Reporting module to run these "pre-canned" reports and/or modify them and save them as a Report Profile for later use.

Basic

On this tab the user selects the report's basic information options, including the report title, date range, and format.

Basic Field Description

^{Table 17. Basic Field Descriptions}

Group

On this tab the user filters and groups the data.

Data can be filtered and grouped by any of the following:

• Facility
• Tasking Group
• Activity Group
• Shift
• Department
• Schedule
• Supervisor
• Activity
• Zone
• Microzone
• Customer
• Employee

To set up groups:

1. Next to each of the items listed above, in the drop-down field on the left, choose whether or not to filter the data. By default, each is set to Include All data.
2. Using the drop-down field, choose to Include or Exclude to filter specific values. When either is chosen, a spy-glass button appears to the right of the second field. Click here to specify particular values to either include or exclude. For example selecting to include the activities "Pick" and "Putaway" and excluding the Shift "First Shift" will result in all records for picking and putaway for employees not on first shift.
3. After specific selections have been made, the user can reset back to "All" by clicking in the drop-down list and choosing "Include All".
4. Use the "Group By Order" drop downs on the far right to summarize the data. Use these numbers to select which fields to group by, and the order to do so. The highest level of data summarization will be determined by the "Group by Order" with the lowest numerical value (1). The data will then be separated by the next lowest "Group by Order" value (2). This will repeat for as many of the "Group by Order" values that are selected. The largest group by value will be displayed as the detail portion of the report
   1. 1) Facility
      2) Shift
      3) Employee
      

      Info
      title Info
      A minimum of one "Group by Order" must be selected. The maximum number of groupings is 5. If Employee is chosen to as a grouping, then the user must select the employee id that will be displayed on the report. The user id will default to the WMS employee id. The available values include: Last Name, First Name WMS id Time Attendance id Payroll id Alternate ID

      
      

An example to summarize this tab is shown below. Here the user has chosen the grouping hierarchy to be 1) Activity Group, 2) Activity, 3) Facility, 4) Employee. The user has also opted to display the detailed employee information, identifying employees by WMS ID.

Metrics

On this tab the user selects the various reporting metrics to be included on the report and optionally applies any additional filtering criteria to the selected metrics. The user can add both Performance and/or Quality metrics onto a single report.

To set up metrics:

1. Click _{Image Added} to add the desired metrics. Each metric will be added as a column on the report.
   
   

   image
   image AH Perf Metric.jpg title Fig.120 Ad Hoc Reporting - Performance Metrics

   
   
2. Select a Criteria from the drop down list.
   

   Info
   title Info
   Listed below are the available Performance metrics: Total Time Break / Lunch Hours Delay Hours Indirect Hours Actual Time on Standard Standard Time Earned Adjusted Standard Time Actual Performance Total Performance Adjusted Performance Effectiveness Utilization Actual Cost ($) – employees' payrates × actual times on standard Standard Cost ($) – employees' payrates × standard times earned Adjusted Cost ($) – employees' payrates × adjusted standard times earned

   
   
3. The next 5 columns are used to filter the data presented in the selected metric (if desired).
4. Comparator1 – a mathematical operator used in conjunction with the field to the right ("Value").
   
   

   Info
   title Info
   Available comparators are: > (greater than) < (less than) = (equal to) <= (less than or equal to) >= (greater than or equal to) "–" is simply a placeholder meaning nothing is selected. It is not a subtraction sign.

   
   
5. Value – used in conjunction with Comparator1. Enter a numeric value to constrain the data. For example if Comparator1 is set to "<" and "5" is typed into the Value field, only data which are less than 5 will be displayed on the report.
6. Logical Operator: "AND", "OR". Use this column to join the previous two columns with an additional comparator and value in the next two columns.
7. Comparator2 - an additional comparator.
8. Value – used in conjunction with Comparator2.
9. The next column is used to sort the data. Data can be sorted in either ascending or descending order.
10. Select the order number of each metric. This is the column number in which the metric will appear. Columns appear left-to-right with number 1 being on the far left.
11. If "Sort by Columns" was selected on the Basic screen, all reported data will first be sorted by the column on the far left (having an Order Number of "1"), and then by the second column, then third, etc… Thus it is important to place the column by which you want the data sorted on the far left (Order Number = 1). If "Sort by Groups" was selected on the Basic screen, the Sort option here has no effect.
12. At the minimum, for each Metric that is added, a Criteria and Order Number must be selected. All comparators are optional.
13. Click _{Image Added} or _{Image Added} on the far right to add or delete metrics.
14. The columns shown for Quality metrics are the same as Performance, with two exceptions:
    1. Quality Type – the first column on the far left is a listing of all Quality types currently configured in the system. In this example, the user may select any of the 6 available quality metrics.
    2. The second column, "Selected Criteria". Choose whether to report the number of Occurrences of the quality, or a calculated quality percentage.
       1. Quality Percentage is calculated as Occurrence Value / Checked Value.
       2. Given that a Checked Value is not mandatory for each quality entry record, if a particular quality entry does not include a Checked Value, it will not have a Quality Percentage calculated for it. Here's an example to clarify:
          
          

          Quality Entry	Occurrence Value	Checked Quantity	Quality %
          1	5	10	50%
          2	6		-
          3	4	45	8.89%
          4	2		-
          5	4	43	9.30%
          6	5	15	33.33%
          7	0	80	0%
          	Total 26	193	9.33% (18/193)

          
          
15. Once all of the metrics have been added, the report can either simply be run by clicking _{Image Added}, or saved as a Report Profile.
16. Click _{Image Added} and a popup window appears.
    
    

    image
    image AH Save Profile.jpg title Fig.121 Ad Hoc Reporting - Save Profile

    
    
17. Type in a name for the report profile. Report Profile names MUST be unique across all users.
18. If the profile was already previously saved, clicking _{Image Added} will simply overwrite the existing profile settings without prompting for a Profile Name.
19. Alternatively, if an existing profile has been edited, but you want to keep the original profile settings too, click _{Image Added} button to bring up the Profile Name popup and save the Report Profile as a new name.
20. Click _{Image Added} to generate the report in HTML-Crystal Reports.
    
    

    image
    image AH Report.jpg title Fig.122 Ad Hoc Reporting

    
    
21. From there, the report can either be sent to a printer or exported to a variety of formats by clicking _{Image Added}.
    

    Info
    title Info
    Available export formats include: Adobe Reader (.pdf) Microsoft Excel (.xls) Microsoft Excel (data only) – this option removes formatting Microsoft Word (.doc) Rich Text Format (.rtf) Separated Values (.csv)