In the Bursting definition table, create a new bursting definition by specifying its name, type, data source, and other properties.
- You have defined the data set for this data model.
- The data set is sorted or grouped by the element by which you want to split the data in your bursting definition.
- The delivery and formatting information is available to Publisher. You can provide the information at runtime to Publisher in one of the following ways:
- The information is stored in a database table available to Publisher for a dynamic delivery definition.
- The information is hard coded in the delivery SQL for a static delivery definition.
- The report definition for this data model has been created and includes the layouts to be applied to the report data.
To add a bursting definition to the data model and enable bursting in your report:
- On the component pane of the data model editor, click Bursting to create a SQL data set to create a bursting query.
- On the Bursting definition table, click the Create new Bursting button.
- Enter the following for this bursting definition:
Name - Enter a name for the query. For example, Burst to File.
Type - Select SQL Query. SQL Query is currently the only supported type.
Data Source - Select the data source that contains the delivery information.
- In the lower region, 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.
Enable Consolidated Output - Select the Enable Consolidated Output option to generate a single consolidated report.
SQL Query — Enter the query to construct the delivery XML.
Attachment — You can attach external PDF files to your bursted PDF output.
- In the Report Properties dialog, select Enable Bursting to enable bursting for a report.
Deliver Byelements reside in an XML document stored as a
CLOBin your database, you must enter the full XPATH in the
Attach PDF to Reports using Bursting Engine
You may have a requirement to attach PDFs along with invoices for customers. You can now attach these documents as an attachment along with the invoice while bursting.
- Click the Attachment tab.
- Select the content server name from the Attachment Repository LOV.
- Define the SQL query for the attachment in the Content Server.
The column alias names KEY and ATTACHMENT_ID are mandatory. The SQL query uses the KEY and the ATTACHMENT_ID (which map to the document id of the PDF in the content server) to create an association between the PDF report and the PDF attachment.
- Click Save icon after you make changes to the data model.The PDF attachments are delivered to recipients along with the main report as a single PDF file.
- Click the View Data button.
- Click View to view the data.
- Save the data by clicking Save As Sample Data.
- To create a report based on the data model that you created, click Create Report.