BI Publisher Report Bursting

What is report bursting?

Rather than giving a definition, think of what it does as explained below and build up the definition yourself. 

Using BI Publisher’s bursting feature you can split a single report based on a key in the report data and deliver the report based on a second key in the report data. Driven by the delivery key, you can apply a different template, output format, delivery method, and locale to each split segment of your report. Example implementations include:

• Invoice generation and delivery based on customer-specific layouts and delivery preference

• Financial reporting to generate a master report of all cost centers, 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

 How does the BI Publisher bursting work?

BI Publisher will build the delivery XML data set based on the sql query that was used in creating the result set. The delivery data in this XML document is used as a mapping table for each Deliver By element. 

As you know, for report bursting to work, you need to supply two result set elements that determines the following: 

The Split By element is the data element from the report file that you wish to split the report by. For example, to split a batch of invoices by each invoice, you may use an element called CUSTOMER_NAME.

 The Deliver By element is the data element from the report file by which to determine the delivery method. In the invoice example, it is likely that each invoice will have delivery criteria determined by customer, therefore the Deliver By element may be CUSTOMER_ID.

 How does the delivery XML look like in BI Publisher?

<ROWSET>

<ROW>

<KEY></KEY>

<TEMPLATE></TEMPLATE>

<TEMPLATE_FORMAT></TEMPLATE_FORMAT>

<LOCALE></LOCALE>

<OUTPUT_FORMAT></OUTPUT_FORMAT>

<DEL_CHANNEL></DEL_CHANNEL>

<PARAMETER1></PARAMETER1>

<PARAMETER2></PARAMETER2>

<PARAMETER3></PARAMETER3>

<PARAMETER4></PARAMETER4>

<PARAMETER5></PARAMETER5>

<PARAMETER6></PARAMETER6>

<PARAMETER7></PARAMETER7>

<PARAMETER8></PARAMETER8>

<PARAMETER9></PARAMETER9>

<PARAMETER10></PARAMETER10>

</ROW>

</ROWSET>

where

• KEY is the Delivery key and must match the Deliver By element. The bursting

engine uses the key to link delivery criteria to a specific section of the burst data.

• TEMPLATE – is the name of the Layout template to apply. Note that the value is the

Layout name (for example, “Invoice”), not the template file name (for example,

invoice.rtf).

• TEMPLATE_FORMAT – is the format of the layout template. Valid values are:

• RTF

• PDF

• ETEXT

• XSL_FO

• LOCALE – is the template locale, for example, “en-US”.

• OUTPUT_FORMAT – is the output format. Valid values are:for example: pdf, html,

excel.

• HTML

• PDF

• RTF

• EXCEL

• DEL_CHANNEL – is the delivery method. Valid values are:

• EMAIL

• FAX

• FILE

• FTP

• PRINT

• WEBDAV

Channel	Parameter1	Parameter2	Parameter3	Parameter4	Parameter5	Parameter6	Parameter7
EMAIL	Emailaddress	cc	From	Subject	Message body	Attachment tru/false(For PDF, always set this parameter to true)	Reply-to
Printer	PrinterGroup	Printer	Number ofcopies	Sides	Tray
Fax	Fax serverName	Fax Number
WEBDAV	ServerName	Username	Password	RemoteDirectory	Remote FileName
File	Directory	File Name
FTP	ServerName	Username	Password	RemoteDirectory	Remote FileName

Do you need BI Scheduler to work for report bursting?

Of Course, Yes.

Thanks for your feedback……