Bursting By FTP

  1. Select the appropriate Data Model and click on “Edit”.

  2. Select “Bursting”.

  3. Below the “Bursting” heading, click on the “+” sign and a new row will appear.

  4. Enter SFTP under the Name column.

  5. Select “SQL Query” under the Type Column.

  6. Select “Analytics” under the Data Source Column.

  7. Copy and paste the template below in the “SQL Query” section.

select DISTINCT

RESORT KEY,

'Arrivals_Report’ TEMPLATE,

'RTF' TEMPLATE_FORMAT,

'en-US' LOCALE,

'PDF' OUTPUT_FORMAT,

'FTP' DEL_CHANNEL, -- Can be any of the output types part of the Template

‘REPORT’ OUTPUT_NAME,

'HGBUSFTPProfile-2' PARAMETER1, --sftp server name

'/OCRNA' PARAMETER4, --remote directory

'Arrivals_Report - '||Resort||'_'||to_Char(Sysdate-1,'YYYYMMDD') PARAMETER5,

'true' PARAMETER6

from RESORT

Once the template is pasted, modify the Query as below:

  • RESORT KEY – No need to modify.

  • TEMPLATE – The report name that will be used for bursting. The report name can be retrieved from the Properties menu of the report.

  • TEMPLATE_FORMAT – No need to modify. The resulting report will still be delivered in the format that was specified in report properties.

  • LOCALE – This defaults to the user account’s locale/location setting.

  • OUTPUT_FORMAT – The output format of the delivered report such as PDF.

  • DEL_CHANNEL – This indicates the delivery channel for the report. In this case, “FTP” is used.

  • RESORT OUTPUT_NAME – The output name is not used. In this case, leave the line as “REPORT OUTPUT NAME.” The actual file name will be indicated in Parameter 5.

  • PARAMETER 1 – This indicates the FTP server’s name. If the SFTP is set up, you can find the server’s name under Schedule, Output tab, Add Destination, FTP Server field.

  • PARAMETER 4 – This indicates the remote directory. In this example, the remote directory is /OCRNA. If the SFTP is set up, you can find the remote directory name in the application portal menu under Controls, SFTP, Remote Directory field.

  • PARAMETER 5 – This indicates the file name. For example, Arrivals_Report - '||Resort||'_'||to_Char(Sysdate-1,'YYYYMMDD') is used.

  • PARAMETER 6 – Indicates if the email is secure. Leave this value as “TRUE.”

  1. Click on the “Save” icon. Bursting is now set up on the Data Model.

  2. Return to the “Catalog” screen and select “Edit” on the BIP report to be delivered.

  3. Select “Properties” and check the box for “Enable Bursting” in the “General” tab.

  4. Click “OK”.

  5. Return to the catalog, click on “More” on the BIP report and select “Schedule”.

  6. In the “Schedule Report Job” window, select the “Output” tab.

  7. Check the “Make Output Public” check box to make report public.

  8. Check the “Save Data for Republishing” check box to retain data for republishing.

  9. Check the “Compress output prior to delivery” to send report in compressed format.

  10. Users can designate outputs and destinations.

  11. In the “Schedule” tab, select “Frequency”

    1. Once

    2. Hourly/Minute

    3. Daily

    4. Monthly

    5. Annually

    6. Specific Dates

  12. Select “Run Now” or a designated start date and time.

  13. In the “Notification” tab, check the “Notify By” check box and enter the recipient email address. Use “,” to separate multiple email addresses.

  14. Check “Report completed” to send notification when report is completed.

  15. Check “Report completed with warnings” to send notification when report is completed with warnings.

  16. Check “Report failed” to send notification when report fails to complete.

  17. Check “Report skipped” to send notification if report was skipped.

  18. Click “Submit” and enter a “Report Job Name”.