Bursting :BIP 11g

Bursting is the process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations.

A single bursting definition provides the instructions for splitting the report data, generating the document, and delivering the output to its specified destinations.

Before to proceed once review the scheduler configuration

Reviewing the Scheduler Configuration:

1.a. Log in to Oracle BI Publisher and go to the Administration page.

b. On the Administration page, in the System Maintenance section, click Scheduler Configuration to examine the database connection



2 .a. The Scheduler Configuration page appears. Examine the Database Connection area. It should show the JNDI connection by default.



b. Click Test Connection. A confirmation message appears if the database connection is successfully established.

3 .Click the Scheduler Diagnostics tab. Review the results. The Result area must show “passed” as indicated in the following screenshot.

Scheduling a Report to Burst to a File Location:

Here we are going to burst a rpoert into our local drive.

Prerequisite:You will need to create a folder under your local drive named BIP. This is the folder to which the reports will burst when you schedule the report to burst.

1 .a. From the Catalog page, navigate to My Folders and select New > Data Model.

b. Create a Dataset Bursting_DS.



2 .a. Click the Bursting node in the Data Model pane. This will open the Bursting pane.



b. Click the add icon in the Bursting pane. The Bursting pane expands and provides an additional definition area.



c. Enter the following information in the Bursting panes:



3.a. In the SQL Query pane below the Query Builder button, copy and paste this code:

select
d.department_name KEY,
'SimpleRTF' TEMPLATE,
'RTF' TEMPLATE_FORMAT,
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT,
'FILE' DEL_CHANNEL,
'D:\BIP' PARAMETER1,
d.department_name || '.pdf' PARAMETER2
from
departments d

b. Your output will be delivered to the folder specified in the bursting model. In this example, it is BIP. Notice that the code includes the name of the template (SimpleRTF). The Data Model should look like this:



Here is a brief description of the bursting definition used in the example:

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: It is an element from the data that will govern how the data is split. For example, to split a batch of departments by each invoice, you may use an element called department_name. The data set must be sorted or grouped by this element.


• The Deliver By element: It is the element from the data that will govern how formatting and delivery options are applied. In this example, it is likely that each department will have delivery criteria determined by customer, therefore the Deliver By element may also be department_name.


• The Delivery Query is a SQL query that you define for Oracle BI Publisher to construct the delivery XML data file. The query must return the formatting and delivery details. It will also define the path to which the data will be delivered. In this example it is D:\BIP.

c. Click Save to save the Data Model.

4.a. Create Report for this data model and open the Report Properties .



b. In the General tab in the Advanced area, select the Enable Bursting check box and ensure that “Burst to File” is selected from the drop-down list.

c. Click OK.

d. Click Save in the report header.

5.Create a Report Job  by

Click New > Report Job to schedule this report with bursting as the output option.

and select this report path in the General tab



6.On the Output tab, select the “Use Bursting Definition to Determine Output & Delivery Destination” check box to enable bursting. Observe that the other options for output will be hidden when this check box is selected.



7 .On the Schedule tab, select Frequency to report as Once and the Run Now option.

8.If the Notification tab is disabled in your instance, you don't have to define anything here.

Note: You will be able to use this option only if a delivery channel is set up in your environment. Without a mail server set up, this option will be disabled. In this example, it is shown as user@localhost.com. You can enter the email address configured to your mail server.

9. Name the scheduling job as Bursting2File in the Submit Job dialog box, and then click Submit.

10.a. From the Catalog, select the Salary Report for Bursting report. Click the Job History link.

The Report Job History for the recent schedule job Bursting2Fileis listed as successful.

You can click Report Job to view the details.



11 .Navigate to the BIP folder and review the contents displaying the burst reports at the specified location. In this example, it is the BIP folder that you have created as part of the prerequisite.



The steps above demonstrated the scheduling of a report to burst to a file location.

Additional Info:

To burst the report to email ,give the bursting definition in the following format in the 3^rd step(above shown).

select

     d.department_name KEY,

     'SimpleRTF' TEMPLATE,

     'RTF' TEMPLATE_FORMAT,

     'en-US' LOCALE,

     'PDF' OUTPUT_FORMAT,

     'EMAIL' DEL_CHANNEL,

     d.department_name||' Department Salary Report' OUTPUT_NAME,

     'to@mycompany.com' PARAMETER1,

     'cc@mycompany.com' PARAMETER2,

     'bipublisher@oracle.com' PARAMETER3,

     'Publisher Bursting Dept: '||d.department_name  PARAMETER4,

     'BODY: Bursting Sample for Department: '||d.department_name  PARAMETER5,

     'true' PARAMETER6,

     'reply_to@mycompany.com' PARAMETER7

from

     departments d





And follow the remaining steps as mentioned above to burst the report to email.