Bursting By Email

  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 the email address for delivery under the Name column.

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

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

  7. Under the “Bursting Query | Attachment” heading, users can use the “Split By” drop down menu to separate reports by categories such as “by property”.

  8. Users can also use the “Delivered By” drop down menu to email reports by categories such as by property.

  9. Do not check the “Enable Consolidated Output” and “Group Data by Split Key Values” check boxes.

  10. 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,

'Email' DEL_CHANNEL, -- Can be any of the output type part of the Template

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

'xxx.xxx@xxx.com' PARAMETER1, -- TO ADDRESS

'yyy.yyy@yyy.com' PARAMETER2, -- CC ADDRESS

'noreply_cds_gbu-analytics@gbua.ocs.oraclecloud.com' PARAMETER3, -- FROM ADDRESS

'Bursting Arrivals Report Sample' PARAMETER4,

'Attached is the output for '||RESORT ||'.csv' 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, “email” is used.

  • RESORT OUTPUT_NAME – The file name that appears. In this example, the file name will be “Arrivals_Report – Property Name_System date minus 1 day” in YYYYMMDD format.

  • TO ADDRESS – The Email address/es to which the report will be sent. To enter multiple email addresses, use the following format: ‘xxx@xxxx.com,yyy@yyyy.com’

  • CC ADDRESS – The CC Email address/es. To enter multiple email addresses, use the following format: ‘xxx@xxxx.com,yyy@yyyy.com’

  • FROM ADDRESS – Indicates the email address from which the report will be sent.

  • PARAMETER 4 – Indicates the subject line of the email.

  • PARAMETER 5 – Indicates the email body.

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

  1. Click on the “Save” icon. Bursting by email 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.

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

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

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

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

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