bip 2 - bursting
DESCRIPTION
BIP 2 - BurstingTRANSCRIPT
Oracle BI Publisher Bursting
Prepared BySuganthi S
Enterprise Application Services
2
Agenda
HCL Methodologies
1. Brief Introduction – BI Publisher
2. Bursting and Delivery
a) Why Bursting?
b) Overviewc) How do I burst the document? How do I deliver the burst file? Where do I deliver the burst file? What should the delivered file look like?
d) Delivery Channels
e) Bursting Control File
e) Complex Scenarios
f) Points to Remember
g) Delivery Without Bursting
Enterprise Application Services
3
Report Templates
XML DataReport Output
XSL
XML EFT
Brief Introduction – BI Publisher
Enterprise Application Services
4
Bursting and Delivery - Overview
BI Publisher's bursting engine: - Accepts a data stream and - Splits it based on multiple criteria, - Generates output based on a template, - Then delivers the individual documents through the delivery channel of choice.
Bursting processes a single file that may contain multiple documents and splits it into individual reports.
Enterprise Application Services
5
Bursting and Delivery - Overview
The engine provides a flexible range of possibilities for document generation and delivery.
‘Delivery Engine’ engine works in conjunction with the bursting engine to deliver documents that have been burst. This engine has the capability to email, fax print and output documents to the file system.
Examples:
• Invoice generation and delivery based on customer-specific layouts and delivery preference.
• Financial reporting to generate a master report of all cost center's, bursting out individual cost center reports to the appropriate manager.
• Generation of payslips to all employees based on one extract and delivered via e-mail
Enterprise Application Services
6
Bursting and Delivery – Delivery Channels
Email - Email connects to your existing mail server and forwards the data file through using SMTP. We need to provide following details as a parameter:
Fax - Fax utilizes CUPS (Common UNIX Printing System) and requires hardware
in order to actually fax the document. We need to provide phone number to send Fax.
Print - Print utilizes CUPS as well to communicate with physical printers.
File - File system will do file transfer to specific directory.
• Server, • Port, • Sender Email, • Reply-To, • To, • Cc(optional), • Bcc(optional),• Subject, • Content-type(text/html),• Attachment(True/False).
Enterprise Application Services
7
Bursting and Delivery – Bursting Control file
XML Control file will instruct the bursting program to burst based on XML tag will been used to spilt the XML file, the RTF location and output type format.
The structure of the XML control file is represented in the following diagram:
Enterprise Application Services
8
Bursting and Delivery – Bursting Control file
Enterprise Application Services
9
Bursting and Delivery – XML Publisher Report Bursting Program
After running the report as a standard concurrent request, we must run XML Publisher Report Bursting Program.
This second concurrent request is what reads the uploaded bursting control file and applies it to the XML output from the first request for bursting and delivery.
The XML Publisher Report Bursting Program creates its own report called the Bursting Status Report that will show each document that was burst from the batch, how it was delivered and the status of the delivery.
When using an Oracle Report or Data Template, the “After Report” trigger can be utilized to submit the XML Publisher Report Bursting Program.
When using an PL/SQL, submit the XML Publisher Report Bursting Program after generating the XML Data in code.
We need to pass Report Concurrent Request Id and Debug Flag as a parameter for this.
Enterprise Application Services
10
Bursting and Delivery – XML Publisher Report Bursting Program
Enterprise Application Services
11
Bursting and Delivery – XML Publisher Report Bursting Program
Modifying After Report Trigger to call the ‘Burst Program’
Enterprise Application Services
12
Complex Scenarios
Multiple Templates & Multiple level of bursting
Enterprise Application Services
13
Points to remember
• Mention Correct group in Request Select.
• Need to mention correct Territory name if is defined in Template Definition.
• Mention unique file name.
• No Data - XML Publisher Report Bursting Program complete with error if no data found in report.
• Email Server - Right email server name and port.
• Make sure there is no any space in Busting control XML Tags.
Enterprise Application Services
14
Delivery Without Bursting - R12.1.3
New in version 12.1.3, Oracle has added a button to the Submit Request form and OAF Submit Request train that allows the use of the BI Publisher Delivery Manager for IPP Print, Email, Fax and FTP.
Functionality allows a user to submit the report (as is) to a remote destination of their choosing.
Enterprise Application Services
15
Delivery Without Bursting
Enterprise Application Services
16
Delivery Without Bursting
Enterprise Application Services
17
Delivery Without Bursting
Enterprise Application Services
18
Delivery Without Bursting
Q&A
Thank you