Managing an Existing Table Report

Objective

After completing this lesson, you will be able to manage existing SAP SuccessFactors Table Reports.

Report Sharing

Sample report sharing options.

The Share action enables a report creator to share the report with other users. Sharing is covered in the Report Center unit.

Report Duplication

The Duplicate action enables a report creator to copy the report definition of an existing Table Report. This is useful when you wish to create a similar report with different filter criteria or if you wish to create similar reports with different scopes of user data. A new report is created in Report Center with the name Original Report Name Copy. The user who duplicated the report will be the author of the new report.

Note

Copying a report that you have shared with others does not automatically share the new copy of the report. You must set up each shared report separately.

Deletion

To confirm, choose Delete.

The Delete option allows you to delete a report definition.

Report Definition

The Export action will save a copy of the definition of the table report. It creates an SFR file to download. The field does NOT contain any data, only the definition of the table report queries.

Sometimes, you may want to export your report definition, either for version controlling, sharing the definition offline with a colleague, or moving the report from a test site to the production site.

Hint

When you are saving versions, you may wish to indicate time, date, and other identifying information so that you know which version is which in the future.

Version Control

As you edit and update your report definition, you overwrite the report each time you save a change. By using Export report definition, you can download copies of the report definition and upload later to revert to a previous version.

Offline Sharing

Sharing reports creates a link between the report creator's report and the shared version. The person with whom the report has been shared cannot modify the report definition. If a colleague would like to create their own report similar to yours, you could export the report definition and e-mail the file. Your colleague can take that file and upload it into their report list. The format of the file will be shown by the extension .sfr, and the file will only be readable within the system; it will not be something that can be viewed and changed offline.

Report Definition

In the Report Center, choose Import.

If you have downloaded a report definition, you may upload it using the Import button in Report Center. The import is available to any users who have permission to create reports.

Exercise: Create a Single Domain Table Report

Business Example

In this exercise, you will create a single domain Table Report for Performance Management.

Steps

  1. From the main navigation menu, select Reporting.

  2. Choose New.

  3. Select Table and choose Select.

  4. Ensure that Single Domain Report is selected.

  5. Select Performance Management form the Reporting domain dropdown.

  6. Choose Select.

  7. Enter Goals and Ratings in the Report Name field.

  8. In the Description field, enter Used in [Today's Date] Table Reports training.

  9. Deselect the Remove Styling checkbox.

  10. Select Save.

  11. Select People on the Report Builder bar.

  12. Select Refine Criteria.

  13. Select Logged In User from the Team Manager dropdown list.

  14. Select Other Filters from Team Reporting Type.

  15. Select OK.

  16. Select Save.

  17. Select Data Sets on the Report Builder bar.

  18. Choose Select Template.

  19. Select the Performance Evaluation.

  20. Select OK.

  21. Select Save.

  22. Select Columns on the Report Builder bar.

  23. Choose Select Columns.

  24. Select Subject from the All Columns area.

  25. Select the checkboxes for Subject Username, Subject First Name, Subject Last Name, Subject Department, Subject Division, and Subject Location.

  26. Select Performance from the All Columns area.

  27. Select the checkbox for Overall Performance Rating.

  28. Select Section Fields from the All Columns area.

  29. Select the checkboxes for Section Name and Section Rating.

  30. Select Done.

  31. Select Rearrange Columns.

  32. Drag Overall Performance Rating to the bottom.

  33. Select OK.

  34. Select Sort Columns.

  35. Select Add another sorting level.

  36. Select Subject Division from the Column dropdown menu.

  37. Select Add another sorting level.

  38. Select Subject Last Name from the Column dropdown menu.

  39. Select OK.

  40. Select Save.

  41. Select Filters on the Report Builder bar.

  42. Select Refine Criteria.

  43. Select Performance from the All Columns area.

  44. Select the checkbox for Overall Performance Rating.

  45. Select By Rule from the Define Overall Performance Rating Filter popup.

  46. Select Add Rule.

  47. Select Is not Null.

  48. Select Add Rule.

  49. Select Is Not Null.

    Note

    Ensure AND is selected.
  50. Select Add Rule.

  51. Select Not equal to and select O.

    Note

    Ensure AND is selected.
  52. Select Add Rule.

  53. Select Not equal to and select Unrated (if exists).

  54. Select Done.

  55. Select Save.

  56. Select Columns on the Report Builder bar.

  57. Choose Select Columns.

  58. Select Subject from the All Columns area.

  59. Select the checkboxes for Subject Username, Subject First Name, Subject Last Name, Subject Department, Subject Division, and Subject Location.

  60. Select Performance from the All Columns area.

  61. Select the checkbox for Overall Performance Rating.

  62. Select Section Fields from the All Columns area.

  63. Select the checkboxes for Section Name and Section Rating.

  64. Select Done.

  65. Select Rearrange Columns.

  66. Drag Overall Performance Rating to the bottom.

  67. Select OK.

  68. Select Preview.

  69. Select Close.

  70. Select Report Center in the breadcrumb navigation (top left corner).

  71. If presented with a Warning popup, select OK.

Exercise: Run a Report Online

Business Example

In this exercise, you will run the Goals, Competencies, and Overall Ratings report online.

Steps

  1. Select the Goals, Competencies, and Overall Ratings link.

  2. Select Run Online.

  3. Select Generate Report.

  4. Select Return to Reports.

Exercise: Share a Report

Business Example

In this exercise, you will share your report with your assigned CEO.

Steps

  1. Select the Action button next to the Goals, Competencies, and Overall Ratings report.

  2. Select Share.

  3. Type the user to share the report within the Name field.

  4. Select the user and Go.

  5. Select the checkbox next to the accounts with which you wish to share the report.

  6. Select the Save button (green icon).

  7. Select Report Center in the breadcrumb navigation (top-left corner).

Exercise: Save as, Delete, Export, and Upload a Report Definition

Steps

  1. Choose the Action button next to the Goals, Competencies, and Overall Ratings report.

  2. Select Duplicate.

  3. Select OK.

  4. Notice the new report created in the Report List.

  5. Select the Action button next to the report you just created.

  6. Select Delete.

  7. Select DeleteOK.

  8. From the Table Report List, choose the Action button next to the Goals, Competencies, and Overall Ratings report.

  9. Select Export.

  10. Save the file to your hard drive (steps vary by browser).

  11. From Report Center, select Import.

  12. Select Browse.

  13. Locate the report definition you just exported.

  14. Select Import.

  15. Select Close.

Summary