Skip to main content

Creating Custom Reports in Pega Robot Manager

Archived

5 Tasks

20 mins

Visible to: All users
Beginner Pega Robot Manager 8.5.1 Robotic Process Automation English
This content is now archived and is no longer updated. Progress is not calculated. Pega Cloud instances are disabled, and badges are no longer awarded. Click here to continue your progress in the latest version.

Scenario

MyTown has used the robotic process automation (RPA) services for two months and has received complaints from users that both Service requests and Inquiries are moving slowly during specific periods. As an administrator, you generate a report that can pinpoint the issue by using the Pega Robot Manager reporting feature.

To ensure that only recent data is analyzed, you must archive data from the oldest date referenced in the system, April 1, 2020, before creating the report. Create two reports: one that shows inquiries that take longer than three seconds and service requests that take longer than five seconds. Finally, make this report Public so that you can share the report with the other product owners and export the report for further use.

Challenge Walkthrough

Detailed Tasks

1 Install the report data RAP

  1. Click the following link to download the application data for MyTown reporting.
  2. In the Save As dialog box, navigate to a local directory, and then click Save to store the file.
  3. Launch the Pega Training instance and log in with the user name RMSysAdmin and password myt0wn@pp1.
  4. In the header of Dev Studio, click Configure > Application > Distribution > Import to access the Import wizard.
  5. In the Import wizard, click Choose file.
  6. In the Open dialog box, navigate to your RobotManagerUsageStatistics.zip file, and then click Open
  7. In the Import wizard, click Next to begin the import process.
  8. Click Next on each screen of the Import Wizard until you reach the completed rules import window.
  9. On the completed rules import window, click Done to exit the Import wizard.

2 Archive old report data

  1. In the header of Dev Studio, click Launch portal > Robot Manager to open the Pega Robot Manager dashboard.
  2. On the Pega Robot Manager dashboard, click Settings to display the Settings landing page.
    settings menu button with reporting
  3. On the Settings landing page, click the Reporting tab to open the Reporting settings.
    reporting settings without configuration
  4. In the upper right, click More > Archive data to display the Archive data dialog box.
  5. In the Archive data dialog box, click the select Hourly row to display the Select date range to archive window.
    archive hourly records
  6. In the Select date range to archive window, in the From date time field, click the calendar icon, and then select  4/1/2020. This date represents the oldest date referenced in the data.
  7. In the To date time field, click the calendar icon, and then select 5/14/2020. This date represents the end of the older data within the system.
  8. Click Next to proceed to the confirmation dialog box.
    select date for archive
  9. In the confirmation dialog box, click Submit to confirm the data archive selection.
    confirm archive data

3 Create your custom usage report

  1. On the Pega Robot Manager dashboard, click Reports to display the Reports landing page.
    report menu button
  2. In the upper-right corner of the Reports landing page, click New Report to create a new report.
    create new report
  3. In the Create new report window, select the following options:
    1. In the Report on list, select Robot Usage Statistics
    2. In the Usage data aggregated section, click Hourly.
    3. In the Report type list, leave the default List option.
      create daily report
  4. Click Submit to close the Create new report window to display the Report Configuration page. 
    report configuration page
  5. Within the Data Explorer section of the Report Configuration page, scroll to the bottom of the Available Columns list, and then drag the Workgroup ID column to the report next to Event Name column
    Add work group ID column to report on the report configuration page.
  6.  In the upper-right corner the Report Configuration page, click Done editing to display the Save as dialog box. 
    done editing report
  7. In the Save report as dialog box, enter the following information:
    • In the Title field, enter Service Request Hourly Usage.
    • In the Description text box, enter Usage report to capture Service Requests over 5 seconds.
  8. Click Submit to save the report.
    save hourly usage report
  9. In the upper right, click the Close icon to close the Report Configuration page
    close report
  10. Repeat steps 1-9 to create a new report with the following information:
    • Title is Inquiry Hourly Usage
    • Description is Usage report to capture Inquiries over 3 seconds
  11. In the My Reports tab, confirm that two new report tiles named Service Request Hourly Usage and Inquiry Hourly Usage are displayed.
    new report tiles

4 Configure filters for new report

  1. On the Report landing page, click the Service Request Hourly Usage report tile to open the report.
  2. In the upper-right corner of the report, click the Edit report button to open the Report Configuration page.
    edit hourly report
  3. On the Report Configuration page, hover over the Workgroup ID column and click the Open icon to display the column menu.
    work group id open menu icon
  4. On the column menu, click Add filter to open the Edit filter window.
    report filter submenu
  5. In the Edit filter window, click Select values to open the Select values dialog box.
  6. In the Select values dialog box, select the Service Request WG check box. 
    service request filter
  7. Click Submit to close the Select values dialog box.
  8. In the Edit filter window, click Apply changes
    apply filter workgroup
  9. On the Report Configuration page, hover over the This Duration column and click the Open icon to display the column menu.
  10. On the column menu, click Add filter to open the Edit filter window.
    this duration filter submenu
  11. In the Edit filter window, in the This duration filter list, select is greater than or equal to. 
    greater than or equal filter
  12. On the right, enter 5000 as the value of the input box to filter for service requests taking longer than 5000 milliseconds or 5 seconds.
  13. Click Apply Changes to close the Edit filter dialog box.
    apply filter duration field
  14. In the upper-right corner of the Report Configuration page, click Done editing
    done editing report
  15. In the upper right, click the Close icon to close Report Configuration page.
    close report
  16. Repeat steps 1-14 to edit the Inquiry Hourly Usage Report to filter using the following information:
    • Add filter on Work group ID column using Inquiry WG
    • Add filter on This Duration column using is greater than or equal to and enter 3000 as the value to filter for inquiries taking longer than 3000 milliseconds or 3 seconds

5 Make your custom reports Public

  1. On the Report landing page, click the Service Request Hourly Usage tile to open the report.
  2. Click Actions > Save as to open the Save report as dialog box.
    save as report
  3. In the Save report as dialog box, enter the following information:
    1. In the Title field, enter Public Service Request Hourly Usage.
    2. In the Description text box, enter Providing a public usage report to capture Service Requests over 5 seconds.
    3. In the Public section of the category list, select Robotics usage.
Note: As an administrator, you can also add a custom report category to your application. For detailed instructions about how to add custom categories to Pega Robot Manager, see Creating a report category.
  1. Click Submit to close the Save report as dialog box.
    public service request report
  2. Click Done editing to finish configuring the report.
    done editing report
  3. In the upper right, click the Close icon to close the report window.
    close public report
  4. In the All reports tab, enter Robotics usage in the Category list to filter the category.  Verify that the Public Service Request Hourly Usage tile is displayed.
    all reports robotics usage
  5. Repeat steps 1-6 to create the Public Inquiry Hourly Usage report.


Available in the following mission:

We'd prefer it if you saw us at our best.

Pega Academy has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice