KEMBAR78
Sample Bursting Query | PDF | Information Retrieval | Sql
Scribd
Upload
247 views2 pages

Sample Bursting Query

The document provides an example of a bursting query for delivering an invoice report to customers via email in Oracle Transactional Business Intelligence. It details the necessary SQL code to generate a delivery dataset, utilizing customer information from a database table named 'CUSTOMERS'. Key parameters such as CUSTOMER_ID, email addresses, and formatting preferences are included in the query for dynamic report generation.

Uploaded by

achref
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
247 views2 pages

Sample Bursting Query

The document provides an example of a bursting query for delivering an invoice report to customers via email in Oracle Transactional Business Intelligence. It details the necessary SQL code to generate a delivery dataset, utilizing customer information from a database table named 'CUSTOMERS'. Key parameters such as CUSTOMER_ID, email addresses, and formatting preferences are included in the query for dynamic report generation.

Uploaded by

achref
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Sample Bursting Query https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/sample-burst...

Designing Pixel-Perfec… Search

Cloud / Cloud Applications / Oracle Transactional Business Intelligence

Designing Pixel-Perfect Reports in Oracle


Transactional Business Intelligence

Title and Copyright Information



 Preface Sample Bursting
 Part I Model Data for Pixel-Perfect Query
 Reports
This example of a bursting query is
  � Use the Data Model Editor based on an invoice report. This
report is to be delivered by
  � Create Datasets
CUSTOMER_ID to each customer's
individual e-mail address
 � Structure Data
This example assumes that the
 � Add Parameters and Lists of Values delivery and forma�ing preferences
for each customer are contained in a
 � Add Event Triggers database table named
"CUSTOMERS". The CUSTOMERS
 � Add Flex�elds
table includes the following columns
that will be retrieved to create the
 � Add Bursting De�nitions
delivery XML dynamically at runtime:

About Bursting • CST_TEMPLATE

What is the Bursting De�nition? • CST_LOCALE

Prerequisites for Con�guring


• CST_FORMAT
Bursting
• CST_EMAIL_ADDRESS
Add a Bursting De�nition to Your
Data Model with an SQL Query
The CUSTOMER_ID will be used as
the KEY and also to de�ne the output
De�ne the Query for Delivery XML �le name.

Pass a Parameter to the Bursting The SQL code to generate the


Query
delivery dataset for this example is as

1 sur 2 5/23/2025, 12:56 AM


Sample Bursting Query https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/sample-burst...

follows:

select distinct
 Copy
CUSTOMER_ID as "KEY",
CST_TEMPLATE TEMPLATE,
CST_LOCALE LOCALE,
CST_FORMAT OUTPUT_FORMAT,
CUSTOMER_ID OUTPUT_NAME,
'EMAIL' DEL_CHANNEL,
CST_EMAIL_ADDRESS PARAMETER1,
'accounts.receivable@example.com'
'bip-collections@example.com' PARA
'Your Invoices' PARAMETER4,
'Hi'||CUST_FIRST_NAME||':'|| 'Plea
invoices.' PARAMETER5,
'true' PARAMETER6,
'donotreply@mycompany.com' PARAMET
from CUSTOMERS

 Previous Page Next Page 


Was this page helpful?
Tell us how to improve

© Oracle About Oracle Contact Us Products A-Z Terms of Use & Privacy Cookie Preferences
Ad Choices

2 sur 2 5/23/2025, 12:56 AM

You might also like