Creating a burst report

In this example, you will create the Hours by Team burst report. This report returns the types of hours worked on by a team. The report returns only the data that the receiver of the report is allowed to view. The report returns data from the past seven days.

These parameters are used:

  • GroupID: This parameter is required. Burst reports are distributed to all users in specified security groups.
  • Team: This parameter is optional.
  • WBU_ID: This parameter is optional. It is for test purposes only and runs the report for one user only.
  1. Select Maintenance > System Administration > Toolkit > Workforce Performance - Report Authoring.
  2. Select the Blank template and click Create.
  3. Add the WFMBurst metadata package:
    1. Under Insertable objects, click Select a source.
    2. Select Infor WFM Packages > WFMBurst and click Open.
      The WFMBurst package is displayed on the Sources tab in the Insertable objects pane.
  4. Select Report > Pages > Page1.
  5. Under Select a widget type, click List.
  6. Specify HoursByTeam in both the Name field and the Query Name field and click OK.
  7. Under Insertable objects, click Sources and expand the WFMBurst package and the Bursting Layer folder.
  8. Drag the Burst Work > Burst Team > Keys > WBU_ID query item into the list object.
  9. Drag the Burst Work > Burst Team > Team Name query item to the right of the WBU_ID query item.
    The Burst Team and Burst Employee query subjects in any of the WFMBurst layer's namespaces contain the WBU_ID query item. This item is used as the burst key. The WFMBurst metadata model differs from other models by not applying user security into the Team and Employee elements. This enables Cognos to generate customized reports for different users.
  10. Drag these query items into the list:
    Namespace > Query Subject > Query Item
    Burst Work > Work > Hours
    Burst Work > Work > Overtime Hours
    Burst Work > Work > Exception Hours
    Burst Work > Work > Productive Hours
    Burst Work > Work > Absent Hours
  11. To only include data from the past week, drag the In Last Week filter from the Burst Work namespace into the list, then click OK.
  12. Hold Ctrl and click the headings for the WBU_ID and Team Name columns in the list.
  13. Click Group/Ungroup.
  14. Click Show properties.
  15. Click the WBU_ID column.
  16. Click the Select ancestor arrow and specify List column.
  17. Specify No for the Render property.
    The column is not displayed in the report results page. The WBU_ID query item is not removed from the actual query.
  18. Click Page views > Page structure.
  19. Click Pages - Page1 and set the Query property to HoursByTeam.
    This ensures that the HoursByTeam query is used as the top-level query in the report.
  20. Click Queries and then select the HoursByTeam query.
  21. Change the value of the Override dimension info property to Yes.
    The Dimension info tab is displayed at the bottom of the Data Items pane.
  22. Under Insertable objects, click Sources and then drag the Burst Work > Workbrain Group > Group Name query item into the Data Items section.
  23. Under Insertable objects, click Toolbox.
  24. Drag the Query Calculation object to the Data Items section.
    The Data item expression dialog box is displayed.
  25. Specify Burst Path in the Name field.
  26. In the Expression Definition field, specify this expression: 
    'CAMID("Workbrain:g:' + [Group Name] + '")'

    The Burst Path data item is used to specify the burst recipient when the Burst Options for the report are set.

  27. Click OK.
  28. Select the Dimension info tab.
  29. Under Insertable objects, select the Source tab.
  30. Drag these data items to the Facts section:
    • Team Name
    • Hours
    • Overtime Hours
    • Exception Hours
    • Absent Hours
    • Productive Hours
    • Group Name
  31. Drag the WBU_ID data item to the Dimensions section.
  32. Drag the Team Name data item to the Levels folder in the Dimensions section.
  33. Make the report available as a burst report:
    1. Select Report.
    2. Under RUNNING & VALIDATING, double-click Burst options.
    3. Select Make report available for bursting.
    4. Under Burst Groups, specify this information:
      Query
      Select HoursByTeam.
      Label
      Select WBU_ID.
      Groups
      Click Edit, double-click WBU_ID, and then click OK.
    5. Under Burst Recipient, specify this information:
      Query
      Select HoursByTeam.
      Data Item
      Select Burst Path.
      Type
      Select Directory entries.
    6. Click OK.
  34. Click the HoursByTeam query and select the Projected Data Items tab.
  35. Add filters to the query to create the query parameters:
    1. Click Toolbox and drag the Filter object to the Detail Filters section.
    2. Specify this expression in the Expression Definition field.
      [Burst Work].[Burst Team].[WBT_ID] in ?Team?
    3. Click OK.
    4. Repeat steps 35.a to 35.c to add these filters:
      • [Burst Work].[Burst Team].[WBU_ID] = ?WBU_ID?
      • [Burst Work].[Workbrain Group].[WBG_ID] in ?GroupID?
  36. Select these filters and specify Optional in the Usage property:
    • [Burst Work].[Burst Team].[WBT_ID] in ?Team?
    • [Burst Work].[Burst Team].[WBU_ID] = ?WBU_ID?
  37. Create the prompt for the Team parameter.
    See Creating a prompt page for the Team parameter.
  38. Create the prompt for the GroupID parameter.
    See Creating a prompt page for the GroupID parameter.
  39. Click Save > Save As.
  40. Select a public folder, specify a report name, and click Save.
  41. Update the report output version for bursting.
    See Updating the report output version for bursting.
  42. Register the report in the application.
    See Registering the burst report.
  43. Schedule the burst report and manually run it.
    Scheduling and running the burst report.
  44. Add the burst report to a Launch Pad to make it available to application users.
    See Adding the burst report to a Launch Pad.