Bursting Reports with Oracle BI Publisher
Oracle BI Publisher:
How to Burst and Deliver Documents from BI Publisher Enterprise
Bursting is a feature in BI Report to splitting data into blocks, generating Report for each block and delivering the Report to one or more destinations. The Data is split based on the ‘Key’ Value.
For example, automate sending Birthday Wishes to the employees in your organization.
This can be achieved using BI Publisher’s bursting feature. Here, there are two elements to the data model. One has split a single report based on an element in the data model and second element is a report that is delivered based on the result of the first element
First data model for single report: For all the data
Here, the first element selects all the employees who have birthdays on the current date.
Second data model for Splitting report: This element helps in sending out the actual birthday wish to the employees obtained from the previous list.
- On the Bursting definition table, click the Create New Bursting
- Enter the following for this bursting definition:
Name – for example, “Burst to File”
Type– SQL Query is currently the only supported type
Data Source – select the data source that contains your delivery information
The following figure shows a Bursting definition:
Enter the following for this bursting definition:
Split By – select the element from the data set by which to split the data
Deliver By – select the element from the data set by which to format and deliver the data
- KEY is the Delivery key and must match the Deliver By 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 to apply. Note that the value is the Layout name (for example, ‘Customer Invoice’), not the template file name (for example, invoice.rtf).
- LOCALE – is the template locale, for example, ‘en-US’.
- OUTPUT_FORMAT – is the output format like HTML, PDF etc.
- SAVE_OUTPUT – indicates whether to save the output documents.
- DEL_CHANNEL – is the delivery method like email, print etc.
This feature can be used any many other situations where the same communication has to be sent out to multiple recipients.