- How to schedule reports to run Offline, send to File Transfer Protocol (FTP) or send to Email using Report Distributor tool.
- This KB article should help you to create a schedule report using the tool Report Distributor with or without the Report Center.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
- SAP SuccessFactors HXM Suite
- Report Distributor
- In addition to Email, reports be distributed by File Transfer Protocol (FTP) or Run Offline
- File Formats Supported: PDF, Word, PowerPoint, Excel & CSV
- Tables within the application can now be added directly to new or existing bundles, or exported from within the main UI as Excel files
- Simplify integrations using FTP
- Burst Reports to Managers inboxes as file attachments
- Users are able to continue using the application while a report is running offline
- User must have access to Report Distributor
- To configure FTP address, User must have permission to FTP Configuration screen
- This tool only support Canvas Reports
How to Access the Report Distributor tool:
Without Report Center:
- Go to Home
- Select the Report Distributor tool on the bottom left side of the screen
With Report Center:
- Go to Home
- View Schedules
- Switch to the Legacy Report Distributor Tool
Creating a Bundle
- On the Report Distributor tool, click on "New Bundle"
- Give the Bundle a name
- Select the Export Type (PDF, MS Word & MS PowerPoint)
Adding Items to a Bundle
You can add a Canvas report, Excel Table or CSV Table:
Options for Running a Bundle
- Send to E-mail: Content will be sent to the recipients set up for this bundle.
- Run Offline: Download link will be made available on the Job Status page when content is ready. Content will remain for 7 days.
- Send to FTP: Content will be sent to the FTP server setup for the organization.
Running by E-mail:
- Click on "Edit Recipients" and then in "Add Recipients"
b. Use the Wildcard Search option to search for people to be add to recipients
- The Recipient should be a BizX User for you to add them as Recipients.
- The Report Distributor only looks at the WFA users, the user will need an Analytics permission.
- Make sure all users selected as recipients have access to run the report/queries.
- If one of the recipients listed have no access, the bundle will fail and the next recipients will not receive the e-mail notification/report.
2 - Running Offline
- Select the "Run Offline" button
- Go to "Schedule" > Add
- When running the bundle offline, you will need to set the following:
- When do you want the schedule to start
- What time do you want the schedule to start
- How often do you want the schedule to run (One time, Daily, Weekly or Monthly)
If you wish to schedule the reports for a higher frequency (hourly for example), multiple schedules will have to be set up.
NOTE: Please do not use Report Distributor for Integration Purposes.
- Turn the bundle active.
You can also check the Job Status. The Job has three Status:
- Runtime Failure
Note: Bundles that have been run offline can only be downloaded by the user who created them. The files will only be available for seven days.
3 - Send to FTP
- Select the "FTP" button;
- Click "Go to FTP setup";
- Set the ftp configuration:
- IP Address/Hostname: (the destination host)
- Username: (your username)
- Password: (your password)
- Directory: (give the directory a name)
- File Transfer Protocol: (FTP or SFTP)
You might receive a message "No changes were made" after clicking on Save, but this message is false and the changes will be saved as expected.
Note: If you need that different bundles goes to different folders without overwriting the first bundle's folder, you need to follow these additional steps:
- Select the bundle name;
- Click "FTP Folder Setup";
- Click "Custom" option.
It will enable the field and you can write the folder name already configured for each bundle in the previous step. You can repeat this step for each bundle that need to be in a different folder.
Note: If you will be adding folders inside a Subfolder, you need to type all the folders name level in the text box. Separate the name folder names using slash.
How to delete a bundle:
- Select the bundle
- Under Menu click on File
- Click on Delete
sf, success factors, WFA, ANA, RPT, Distributed, File, Transfer, Protocol, FTP, SFTP, Offline, E-mail, create, New, Bundle, Define, Recipient, Scheduled, Job, Subfolder, Sub Folder Delete bundle , KBA , LOD-SF-ANA-RDT , Report Distributor (Advanced Reporting, ORD) , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To