Split By - select the element from the data set by which to split the dataĭeliver By - select the element from the data set by which to format and deliver the data In the lower region, enter the following for this bursting definition: The following figure shows a Bursting definition: Type- SQL Query is currently the only supported typeĭata Source - select the data source that contains your delivery information On the Bursting definition table, click the Create new Bursting button.Įnter the following for this bursting definition: On the component pane of the data model editor, click Bursting. The report definition for this data model has been created and includes the layouts that will be applied to the report data.
The information is hard coded in the delivery SQL (for a static delivery definition) The information is stored in a database table available to BI Publisher (for a dynamic delivery definition) The information can be provided at runtime to BI Publisher in one of the following ways: The delivery and formatting information is available to BI Publisher. The data set is sorted or grouped by the element by which you want to split the data in your bursting definition You have defined the data set for this data model The query must return the formatting and delivery details.Īdding a Bursting Definition to Your Data Model The Delivery Query is a SQL query that you define for BI Publisher to construct the delivery XML data file. In the invoice example, it is likely that each invoice will have delivery criteria determined by customer, therefore the Deliver By element may also be CUSTOMER_ID. The Deliver By element is the element from the data that will govern how formatting and delivery options are applied. The data set must be sorted or grouped by this element. For example, to split a batch of invoices by each invoice, you may use an element called CUSTOMER_ID. The Split By element is an element from the data that will govern how the data is split. When you set up a bursting definition, you define the following: After you have defined the data sets for the data model, you can set up one or more bursting definitions. Generation of pay slips to all employees based on one extract and delivered via e-mailĪ bursting definition is a component of the data model. Invoice generation and delivery based on customer-specific layouts and delivery preferenceįinancial reporting to generate a master report of all cost centers, splitting out individual cost center reports to the appropriate manager Driven by the delivery element, you can apply a different template, output format, delivery method, and locale to each split segment of your report. Using BI Publisher's bursting feature you can split a single report based on an element in the data model and deliver the report based on a second element in the data model. For each block of the data, a separate document is generated and delivered. The data for the report is generated by executing a query once and then splitting the data based on a "Key" value. Creating a Table to Use as a Delivery Data Sourceīursting is a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations.Configuring a Report to Use a Bursting Definition.Defining the Split By and Deliver By Elements for a CLOB/XML Data Set.Defining the Query for the Delivery XML.Adding a Bursting Definition to Your Data Model.This chapter covers the following topics:
Oracle Fusion Middleware Data Modeling Guide for Oracle Business Intelligence Publisher Adding Bursting Definitions Browser version script Skip Headers
0 kommentar(er)
