Bursting By Email
-
Select the appropriate Data Model and click on “Edit”.
-
Select “Bursting”.
-
Below the “Bursting” heading, click on the “+” sign and a new row will appear.
-
Enter the email address for delivery under the Name column.
-
Select “SQL Query” under the Type Column.
-
Select “Analytics” under the Data Source Column.
-
Under the “Bursting Query | Attachment” heading, users can use the “Split By” drop down menu to separate reports by categories such as “by property”.
-
Users can also use the “Delivered By” drop down menu to email reports by categories such as by property.
-
Do not check the “Enable Consolidated Output” and “Group Data by Split Key Values” check boxes.
-
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.”
-
Click on the “Save” icon. Bursting by email is now set up on the Data Model.
-
Return to the “Catalog” screen and select “Edit” on the BIP report to be delivered.
-
Select “Properties” and check the box for “Enable Bursting” in the “General” tab.
-
Click “OK”.
-
Return to the catalog, click on “More” on the BIP report and select “Schedule”.
-
In the “Schedule Report Job” window, select the “Output” tab.
-
Check the “Make Output Public” check box to make report public.
-
Check the “Save Data for Republishing” check box to retain data for republishing.
-
Check the “Compress output prior to delivery” to send report in compressed format.
-
Users can designate outputs and destinations.
-
In the “Schedule” tab, select “Frequency”
-
Once
-
Hourly/Minute
-
Daily
-
Monthly
-
Annually
-
Specific Dates
-
-
Select “Run Now” or a designated start date and time.
-
In the “Notification” tab, check the “Notify By” check box and enter the recipient email address. Use “,” to separate multiple email addresses.
-
Check “Report completed” to send notification when report is completed.
-
Check “Report completed with warnings” to send notification when report is completed with warnings.
-
Check “Report failed” to send notification when report fails to complete.
-
Check “Report skipped” to send notification if report was skipped.
-
-
Click “Submit” and enter a “Report Job Name”.