Creating the Employee and Team parameters

Adding the Employee and Team parameters filters the report results to only employees or teams that are selected by users of the report. The Employee parameter uses the key for employee ID (EMP_ID), and the Team parameter uses the key for team ID (WBT_ID). These keys are used to connect data across multiple query subjects by identifying a specific employee or team.

To add parameters to a report, add a Data Item in the Detail Filters section of a query with the format [Query Item] in ?Parameter?.

  1. Click Queries > Query Parameters and select the query you created.
  2. Click Sources under Insertable objects and select WFMStandard > Ad-Hoc Query Layer > Work > Employee > Keys.
  3. Drag the EMP_ID query item into the Detail Filters pane.
  4. In the Expression Definition pane, enter this statement to define the expression as the Employee parameter. 
    [Work].[Employee].[EMP_ID] in ?Employee?
  5. Click OK to save the filter.
  6. In the Sources tab under Insertable objects, select WFMStandard > Ad-Hoc Query Layer > Work > Team > Keys.
  7. Drag the WBT_ID query item into the Detail Filters pane.
  8. In the Expression Definition pane, enter this statement to define the expression as the Team parameter. 
    [Work].[Team].[WBT_ID] in ?Team?
  9. Click OK to save the filter.
  10. Click Show Properties.
  11. Highlight the [Work].[Employee].[EMP_ID] in ?Employee? filter, and set the Usage property to Optional.
  12. Highlight the [Work].[Team].[WBT_ID] in ?Team? filter, and set the Usage property to Optional.