1. Designing and Publishing Pixel-Perfect Reports in Oracle Analytics Server
  2. Model Data for Pixel-Perfect Reports
  3. Add Bursting Definitions

7 Add Bursting Definitions

This topic describes the support for bursting reports and how to define a bursting definition in the data model to split and deliver your report to multiple recipients.

Topics:

Prerequisites for Configuring Bursting

This topic lists the prerequisites for configuring bursting.

Before you define bursting in the data model and enable bursting in your report, make sure:

  • The administrator has configured the Publisher connections to data sources, delivery destinations, and the permissions to enable users to access resources.
  • You've defined a SQL query dataset or a dataset from Data Modeler for this data model.
  • The dataset 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.

Use a Visualized Dataset to Add a Bursting Definition to Your Data Model

You can use a visualized dataset to add a bursting definition to the data model, and then enable bursting in your report.

If you want to add the datasets created in the Dataset editor to your bursting definition, make sure you create the correct query in the Dataset editor, because you can't change the key and delivery channels after you add the dataset to the bursting definition in Publisher. See Define the Query for Delivery XML, and create the bursting dataset with the same column names specified in the query for the delivery channel. For example, use column names such as KEY, OUTPUT_FORMAT, DEL_CHANNEL, OUTPUT_NAME, PARAMETER1, and PARAMETER2.

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

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

    • Type - Select DV Datasets to use a visualized dataset.

  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 checkbox to generate a single consolidated report.

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

    • Dataset Name - Browse and select the visualized dataset.

    The bursting query is automatically populated and the bursting query is non-editable.
  5. Save the data model.
  6. 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.