Bursting in Oracle BI Publisher Cloud
Hi,
I need to create a Bursting query for one of the data model. How to write a Bursting query as per my requirement to send Balance total for individual employee.
Can anyone please help me out.Below Query i found in forums but not able to set it up.
SELECT EMP_NAME as KEY,
‘BITemplate’ TEMPLATE,
‘en-us’ LOCALE,
‘PDF’ OUTPUT_FORMAT,
‘true’SAVE_OUTPUT,
‘America’TIMEZONE
‘ENGLISH_HIJRAH’CALENDAR,
‘EMAIL’ DEL_CHANNEL,
‘Balances_Report’OUTPUT_NAME,
‘To Email Addressfor Example:’1234@abcd.com’parameter1,
‘Cc’parameter2,
‘From’ parameter3,
‘Subject’ parameter4
FROM ( Paste SQL Query used for Data Model)
Thanks,
Reddy