✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


Sunday, 17 September 2017

Step by Step on bursting BI Publisher Reports

By on September 17, 2017

Bursting is an important and useful feature of BI Publisher, which enables you to split a single report based on a key .You, can apply a different template, output format, delivery method, and locale to each split segment of your report. 

Following are some example scenarios where bursting can be implemented: Generation of pay slips to all employees based on one extract and delivered via e-mail

Scheduling a report to burst to a file location 

Click on Edit link mentioned below to go the report

Bursting the Report to a shared Location On the Report Properties screen, click the Bursting node in the Report section on the left, to define bursting properties for the report.

This displays the Bursting Properties screen on the right. 

In the General Properties section, select the Enable Bursting option, and then select ROWSET/ROW/DNAME from the Split By drop-down list and ROWSET/ROW/DNAME from the Deliver By drop-down list. 

In the Delivery Data Source section, select BIP as the Data Source, and add the query in the SQL Query section:

Query for Report Brusting:

       DEPT.DNAME  "KEY"
      ,'Bursting_File' TEMPLATE
      ,'D:\Salary' PARAMETER1
      ,DEPT.DNAME||'.pdf' PARAMETER2

Before doing the bursting process, create a folder for e.g. D:\Salary.

Mention the path of the created share folder in the Bursting query as shown below:

Click Save to save the changes you made to the report.

Ensure that you saved the report after defining the Bursting Properties, and click Schedule to schedule this report to burst to the file location defined.

This takes you to the Schedule page. Click Schedule a New Job to define the scheduling job.

On the Schedule Report page that appears, define the following:

In the Job Properties section, select the Burst Report option

Scroll down to define the other options. 

Select the Run immediately option in the Time section and click Submit

This displays the message saying the job is successfully created.

Click the Schedules tab and then click History to see whether the schedule was run successfully.(Click the refresh icon )

Now go to the D:\Salary folder (the delivery destination folder you provided in the query). You can see that the PDF files, which have <DName>. PDF as the titles, are bursted to this file location.

Open one of the files to see the report. 

For example, Accounting. PDF report file looks like this: 

#bursting BI Publisher Reports# How to Burst BI Publisher reports# BI Publisher

mkashu: Step by Step on bursting BI Publisher Reports
Review : Kashif | Kashif
Update: September 17, 2017 | Rating: 4.5

Comment for "Step by Step on bursting BI Publisher Reports"


Post a Comment

Blog Archive