Implementing BI Publisher Bursting (file system)

We are going to work through an example, where we burst our XXHR Duty Roster report into two individual reports, one for each week of our roster, and deliver the reports to a chosen location on the file system (that is, on the Oracle server).

How to do it...

A sample Bursting Control file can be obtained from Oracle (search online or refer to a relevant BI Publisher guide). The following is the XML code for the Bursting Control file that we are going to use in our example (XXHR Duty Roster BC fs.xml). This file is available in the code download bundle. Explanations on key sections of the code will follow.

1. The first thing we need to specify is how we want to split our data. This is done within the following tag and we make reference to our XML data file:

   <xapi:request select="/Roster/Week">

   In our example, we are going to split our data into individual weeks, hence the /Roster/Week level reference.

2. Next, we need to specify how we intend on...