What is report bursting In BI publisher?

Bursting is a feature in BI Report to splitting data into blocks, generating Report for each block and delivering the Report to one or more destinations. The Data is split based on the ‘Key’ Value.

How do you use burst in BI Publisher?

How to Burst and Deliver Documents from BI Publisher Enterprise

  1. Enable Bursting: The easy to explain part -> Click on the ‘Enable Bursting’ checkbox!
  2. Split By: Choose how you want to split/burst the data.
  3. Deliver By: Choose the ‘KEY’ to deliver the data by.

What burst email?

01 Email Blast An email blast, also known as an email broadcast, is when when you send a single email to a group of customers or prospects all at once. For example, you may send an email blast to announce a new feature or to promote a limited-time offer.

How do I email a bi publisher?

Add an Email or SMTP Server to BI Publisher

  1. Log in to BI Publisher and select Administration, Delivery, Email.
  2. Click Add Server.
  3. Enter the appropriate information for your email server and click Test Connection.
  4. Click Apply.

How do you write a bursting query?

Sample Bursting Query. Creating a Table to Use as a Delivery Data Source….Defining the Query for the Delivery XML

  1. KEY is the Delivery key and must match the Deliver By element.
  2. TEMPLATE – is the name of the Layout to apply.
  3. LOCALE – is the template locale, for example, ‘en-US’.
  4. OUTPUT_FORMAT – is the output format.

What is bursting in Peoplesoft?

When you select a burst field, the report generates multiple files at runtime with a separate report instance file generated each time a unique value appears for the Burst by data tag.

How do I send an email blast without showing recipients?

To hide the email addresses from recipients:

  1. Enter addresses into ‘Bcc’.
  2. To help prevent your emails from going into spam folders, add your own address into the ‘To’ field.
  3. Note the number of contacts before sending an email.
  4. Use ‘Undisclosed recipients’ to warn your addressees about bulk messaging.

How do you send a blast email in Outlook?

Launch Outlook and click the “New E-mail” button. Click the “To” button and, if necessary, choose an address book. From here, choose your blast recipients, which appear in alphabetical order. Press and hold down the “Ctrl” key, then click once on each person that you want to include in the group.

What is a bursting query?

The bursting query is a SQL query that you define to provide BI Publisher with the required information to format and deliver the report. BI Publisher uses the results from the bursting query to create the delivery XML.

What is a bursting report?

Burst a report to distribute its contents to various recipients. Bursting is the process of running a report once and then dividing the results for recipients who each view a subset of the data. You use burst reports to send each salesperson only the information they need. …

How does report bursting work in BI Publisher?

Using BI Publisher’s bursting feature you can split data into blocks, generate document for each block and deliver the document to one or more destination. The method by which report bursting is carried out is based on a user defined rules that takes account of security or data distribution.

Is the bursting report output sent by email?

The feature is standard for XML Publisher version 5.6.3 Output is sent via email. User does not need to login to Oracle to get the report The main report template and the bursting templates can be different from each other.

When to burst BI report with HTML attachment?

Normally when we burst the BI Reports we either do the html bursting so that the content will appear in the email body or burst with an attachment so that the end user can open the pdf and view it. However if there is a requirement to combine both of them, then we can use the below bursting SQL:

How does the bursting feature work in bi?

For each block of the data, a separate document is generated and delivered. 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.