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.
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 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 Analytics Server.
To use a dataset from Data Modeler to define bursting in the data model, and then enable bursting in your 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.