SOAIS BLOG - 'Bursting Reports with Oracle BI Publisher'

1
SOAIS is a leading enterprise IT solutions
provider with a passion for customer
satisfaction, technology innovation, and profound
industry and business process expertise. It
offers a full spectrum of technology solutions in
the arena of Oracle Cloud (SAAS PAAS),
PeopleSoft, Worksoft, and niche technology areas
such as AI/ML for enterprises. Founded in 2006,
SOAIS mission has always to bring cost reduction
and innovation that produce a tangible impact on
our customers business. Its continuous
commitment towards excellence has resulted in an
ever-increasing list of more than 100 satisfied
global clients across several verticals. SOAIS
has a global presence in Chicago, Bangalore,
Kolkata and Dallas. The company has a dedicated
Center of Excellence, a flexible global delivery
model and a strong track record of long-term
strategic partnerships with customers. SOAIS is a
Gold partner of Oracle and also has a strategic
alliance with Worksoft.
Enterprise IT Solutions
Putting Customer First
SOAISs Vision To become our customers trusted
partner of choice by helping them create business
value by leveraging technology and innovation.
2
SOAIS BLOG Bursting Reports with Oracle BI
Publisher
http//www.soais.com/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.

3

• 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.
4
Second data model for Splitting report This
element helps in sending out the actual birthday
wish to the employees obtained from the previous
list. 1. On the Bursting definition table,
click the Create New Bursting button. 2. 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
5
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
6

• 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 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.

7
Contact SOAIS-

• SOAIS CorporateUnit No-09, Fifth Floor,
  Navigator Building,ITPB, Whitefield Road,
  Bangalore 560066.Call 91-80-40071234Business
  Email info_at_soais.comWebsite www.soais.com

SOAIS ChicagoSuite 101, 1979,N Mill St.
Naperville, IL-60563,United States.Call
1-800-262-2427Business Email info_at_soais.comWebs
ite www.soais.com
SOAIS Kolkata2H, KBR Complex,4 Ho Chi Minh
Sarani, Kolkata 700071.Call 91-33-4004
0566Business Email info_at_soais.comWebsite
www.soais.com
SOAIS DallasSuite 300, 15150,Preston Road,
Dallas,TX 75248,United States.Call
1-800-262-2427Business Email info_at_soais.comWebs
ite www.soais.com