BI Publisher (MOSC)

MOSC Banner

Bursting in Oracle BI Publisher Cloud

edited Mar 25, 2019 5:09AM in BI Publisher (MOSC) 7 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center