BI Publisher Bursting in Oracle Fusion

Bursting is a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations. The data for the report is generated by executing a query once and then splitting the data based on a "Key" value. For each block of the data, a separate document is generated and delivered.

A bursting definition is a component of the data model. After you have defined the data

sets for the data model, you can set up one or more bursting definitions. When you set

up a bursting definition, you define the following:

• The Split By element is an element from the data that will govern how the data is

split. For example, to split a batch of invoices by each invoice, you may use an

element called Department. The data set must be sorted or grouped by this

element.

• The Deliver By element is the element from the data that will govern how

formatting and delivery options are applied. In the invoice example, it is likely that

each invoice will have delivery criteria Person_Id.

• The Delivery Query is a SQL query that you define for BI Publisher to construct the

delivery XML data file. The query must return the formatting and delivery details.

Lets suppose you have created a report which is having person information. It is having list of person name, its position and organization. Considering we have a requirement to split this information based on organization.

In above scenario we want to have separate file for organization “Accounts Payable” and another one for “Emerging Solutions Administration” we need to burst or split this report.

To Achieve that  process is same as :-

Step 1 :- Create Data model  as per requirement .

Step 2 :- Create layout as per requirement.

Step 3 :- Now we will start to create bursting query.

So we have separate side tab for bursting in data model click on that :-

Give name to bursting DM  select datasource as ApplicationDB_HCM, because we are fetching HCM tables.

In above query I might have skipped few parameters but you can check all the parameter values in Fusion Guide for BI report.

a. KEY – This value much match the value of the unique identifier that you chose for the ‘Deliver By’ field in step 3.

For example: When writing the query, you want to return the person_id for the KEY column. This means that your ‘Deliver By’ field must be the XML element that represents the person_id so that BIP can match them up.

b. TEMPLATE – Name of the template to apply as setup in BIP Enterprise

c. LOCALE – Locale of the template d. OUTPUT_FORMAT – How you want the final published output to be formatted. (i.e. PDF, HTML, Excel, etc….) e. DEL_CHANNEL – The delivery channel to use to send the newly burst and formatted data through. f. PARAMETERS1-10 – These fields define the parameters for the specified delivery channel. i.e. email server, email address, file path, etc see below :-

Parameters 1-10 

Save the report and run you will get the email split by Organization. You will see your mail box flooded with the emails of the report output.