Add a Bursting Definition to Your Data Model with an SQL Query
You can add a bursting definition to your data model.
Bursting doesn't support global functions in data model. If a data model contains global functions, the XML generated by a bursting job doesn't include the tags for the global functions. The global function elements are at the end section of the XML output. The XML output is cut based on the Split By element specified in the bursting definition. The global function elements can't be included in the split XML document.
For example, consider the following XML output and the Split By element. The bursted XML document won't contain the global function elements:
-
XML output:
<Data><G1><Invoice_id>10</Invoice_id><Invoice_Num>abcd#1</Invoice_Num>,,,</G1><GLobalFunc1>InvoiceAccountCode</GLobalFunc1></Data>
-
Split By element:
/Data/G1/Invoice_id
-
Bursted XML document:
<Data><G1><Invoice_id>10</Invoice_id><Invoice_Num>abcd#1</Invoice_Num>,,,</G1></Data>
In the Bursting definition table, add a bursting definition by specifying its name, type, data source, and other properties.
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.
Attach PDF to Reports using Bursting Engine
You might have a requirement to attach PDFs along with invoices for customers. You can attach PDFs to reports while bursting.