Editing an Existing Table Report

Objective

After completing this lesson, you will be able to edit an existing SAP SuccessFactors Table Report.

Table Report Actions

The table report actions, as described in the following text.

Table Report actions are accessible from the Action icon in the Report Center. The actions available to you depend on whether you are the report creator or viewer. You can also run the report by choosing the name of the table report in the name column.

Report creators (permission create report) may perform the following actions on reports they own / create:

  • Run Report
  • Edit
  • Share
  • Rename
  • Delete
  • Export report definition
  • Duplicate
  • Label

Administrative permissions exist to allow the following actions:

  • Manage all table report
  • Change Author
  • Restore Deleted Report

Report consumers (permission run report) may:

Run Report

User permissions exist to allow for the following:

Scheduling reports to run offline

Edit an Existing Table Report

Choose More, then choose edit.

This option opens the report definition and allows you to access any of the steps and settings you set up previously. When finished editing, save your report before returning to the Report List.

Note

Editing a report that you have shared with others will update the shared version immediately.

Table Report Guardrails

SAP SuccessFactors has implemented guardrails to allow for an optimal experience when running table reports. Guardrails are system checks built into application features to ensure they are being used without causing outages and timeouts. You will be guided with messages that recommend the best way to use the application. SAP SuccessFactors introduced the guardrails to ensure fair usage of the Table Reporting capability and to optimize user experience with SAP SuccessFactors.

System CheckMessage Displayed

Number of cells returned for all table reports:

  • Less than 1 million - execute using online or offline mode
  • Greater than 1 million cells - execute off- line mode only
A message will be presented onscreen informing the user that the cell count is above the allotted threshold.

If you think these guardrails will hinder the output of your report, consider using another tool, such as the Integration Center which is designed to handle larger volumes of data. You can review the document Reporting and Integration Comparison on the SAP Help Portal.

SAP SuccessFactors has the following guidelines for managing reports:

  • Utilize integration tools such as the Integration Center and APIs for a system-to-system integration use case.
  • Run only small reports in online mode.
  • Always run large reports in offline mode and, where possible, schedule large reports to run at off-peak hours.
  • Audit our reports and frequency. If reports are not used, delete them. Adjust the frequency to what you need.
  • Limit the total number of columns output in the report to a "humanly readable" amount. We suggest creating variants of these reports that have a breakdown of different types of data.
  • Consider the total number of rows output in your reports. There are multiple ways the data can be limited:
    • Consider who is running the report. Administrators will have access to large amounts of data.
    • Add filters to your reports to execute for specific departments, divisions, countries, and so on, or other relevant segments of data.
  • Consider the report output while building reports. If the report output is being used for data extraction, include only the fields that are required and remove those that are not.

Run Table Reports

Run Report options highlighted.

Report Viewers and Creators have the same options available when running a report. Reports may be generated in two ways:

1. Online

Running on-demand produces your file immediately, but may take up to several minutes depending on the size of the file. While the report generates, you may not navigate to other areas of the software.

  • Run Online - This option runs the report and generates it onscreen.
  • Download (CSV) - This option creates a downloadable CSV file.
  • Export - This option allows you to generate a downloadable file in PDF, Excel, or PPT format.

Note

There are no formatting options available with these report types aside from what you can do in the resident application of the file type you select.

Note

Any report that takes longer than 15 minutes to run due to the data volume or complexity should be run offline.

Note

When exporting a Table Report, there is no row limit for CSV. The XLS has a row limit of 65536 and XLSX has a row limit of 1,048,576.

2. Offline

Running offline gives you the flexibility to attend other activities while the report processes in the background.

Run Offline - This option allows you to create a named, downloadable file in any of the above formats. The report runs in the background while you are free to do other things. You will be notified through email upon the completion of the report. It may be accessed by navigation to Report CenterView SchedulesMy Jobs.

Run Table Reports Examples

Select Running a Report Online and Offline to see more information.

Summary