1. Designing and Publishing Pixel-Perfect Reports in Oracle Analytics Server
  2. Model Data for Pixel-Perfect Reports
  3. Add Bursting Definitions
  4. Add a Bursting Definition to Your Data Model with a SQL Query

Add a Bursting Definition to Your Data Model with a SQL Query

In the Bursting definition table, add a bursting definition by specifying its name, type, data source, and other properties.

  1. On the component pane of the data model editor, click Bursting to create a bursting query.
  2. In the Bursting definition table, click the Create Bursting button.
  3. Enter the following for this bursting definition:

    • Name - Enter a name for the query. For example, Burst to File.

    • Type - Select SQL Query.

    • Data Source - Select the data source that contains the delivery information.

  4. In the lower region, enter the following for this bursting definition:

    • Split By - Select the element from the dataset by which to split the data.

    • Deliver By - Select the element from the dataset by which to format and deliver the data.

    • Enable Consolidated Output - Select the option to generate a single consolidated report.

    • Group Data by Split Key Values - Select the option to group the data based on Split Key values.

    • SQL Query - Enter the query or click QueryBuilder to construct the bursting query.

    • Attachment - Attach external PDF files to your bursted PDF output, if required.

  5. In the Report Properties dialog, select Enable Bursting to enable bursting for a report.
If the Split By and Deliver By elements reside in an XML document stored as a CLOB in your database, you must enter the full XPATH in the Split By and Delivery By fields.

Attach PDF to Reports using Bursting Engine

You might have a requirement to attach PDFs along with invoices for customers. You can attach PDFs to reports while bursting.

Once a bursting query is defined, you can enter the attachment query in the Attachment tab. The attachment expects the repository source to be a WebCenter content, which can be defined as a data source by the Administrator.
  1. Click the Attachment tab.
  2. Select the content server name from the Attachment Repository LOV.
  3. Define the SQL query for the attachment in the Content Server.
    Publisher doesn't support parameters in the SQL query for attachment.
  4. Click Save icon after you make changes to the data model.
  5. Click the View Data button.
  6. Click View to view the data.
  7. Save the data by clicking Save As Sample Data.
  8. To create a report based on the data model that you created, click Create Report.
Note that the PDF attachments are delivered to recipients along with the main report as a single PDF file. The attachment document isn’t separately embedded, but appended to the report.
If you want to save the entire PDF report along with the attachments as a single consolidated file, then check the option Enable Consolidated Output under bursting query. The consolidated output contains the sequential merge of report and attachment of each burst. A user (with consumer role) who schedules the bursting report job and the Administrator will be able to view the consolidated output in the Job History Details page.