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

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

If you want to add the datasets that are created in Data Modeler to your bursting definition, make sure you create the correct query in Data Modeler, because you can't change the key and delivery channels after you add the dataset to the bursting definition in Publisher. In Data Modeler, you can create data models from scratch, or use your business data previously modeled with Oracle BI Enterprise Edition.

To use a dataset from Data Modeler to define bursting in the data model, and then enable bursting in your report:

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 dataset defined in Data Modeler.

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.

   Dataset Name - Select the dataset defined in Data Modeler.

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.