Wednesday, July 16, 2014

Report Bursting in OBIEE

What is bursting?

Bursting is a process of
-          Splitting data into blocks
-          Generating document for each block
-          Delivering the document to one of more destinations

The data for the report is generated by executing query once and then splitting the data based on a key value. For each block on data, a separate document is generated and delivered.

Using BI Publisher’s bursting feature we can split a single report based on an element in the data model, and deliver the report based on a second element in the data model. Driven by the delivery element, we can apply a different template, output format, delivery method and locale to each split segment of the report. Example implementation are –
-          Report generation for customer with their own company logo on the report.

-          Generation of pay slips to all employees based on one report and delivered to them by email.