Bursting for BIP Efolio Report

  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. For Email Query, copy and paste the template below in the “SQL Query” section.

select DISTINCT

RESORT KEY,

'eFolio_xml_Report' TEMPLATE,

'ETEXT' TEMPLATE_FORMAT,

'en-US' LOCALE,

'TEXT' OUTPUT_FORMAT,

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

RESORT OUTPUT_NAME,

'<To Email Address>' PARAMETER1,

'<CC Email Address>' PARAMETER2, -- CC

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

'Bursting Sample' PARAMETER4,

'Attached is the output for '||RESORT PARAMETER5,

'true' PARAMETER6

from RESORT

For FTP Query, copy and paste the template below in the “SQL Query” section.

select DISTINCT

RESORT "KEY"

'eFolio_xml_Report' TEMPLATE

'ETEXT' TEMPLATE_FORMAT

'en-US' LOCALE

'TEXT' OUTPUT_FORMAT

'FTP' DEL_CHANNEL

RESORT OUTPUT_NAME

'<SFTP Server Name>’PARAMETER1 --sftp server name

'<Directory Path>' PARAMETER4 --remote directory

'<ReportName> - '||Resort||'_'||Sysdate||'.xml PARAMETER5 --file name

'True' PARAMETER6

from RESORT