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.
