Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BI Publisher Bursting Issue

778337Jan 20 2011 — edited Jan 21 2011
Hello everyone,
we can burst the same report to multiple users as shown below. but the issue is if we want to send a same report by each district to tht particular manager email id then wht could be the sql query it has to select tht particular district and the manager email id when bursting..

SELECT department KEY
,'Standard Report' TEMPLATE
,'RTF' TEMPLATE_FORMAT
,'en-US' LOCALE
,'Excel' OUTPUT_FORMAT
,'Email' DEL_CHANNEL
,'abc@abc.com,def@def.com,ghi@ghi.com' PARAMETER1
,'qwe@qwe.com' PARAMETER2
,'asd@asd.com' PARAMETER3
,'Standard Report' PARAMETER4
,'Find the Report Below.' PARAMETER5
,'true' PARAMETER6
,'donotreply@nowhere.com' PARAMETER7
FROM
dual

Thanks...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2011
Added on Jan 20 2011
2 comments
307 views