1. Designing Pixel-Perfect Reports in Oracle Analytics Cloud
  2. Build Data Models for Pixel-Perfect Reports
  3. Add Bursting Definitions
  4. Use a Visualized Dataset to Add a Bursting Definition to Your Data Model

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.