Oracle BI Publisher – Bursting With Multiple Data Model Queries

As the split by logic requires only one parent – it is always advised to design queries in a dependent manner, considering one parent with the child under it

In the below Data Model — G4 is the parent with three children linked with : KEY

Bursting level they are split by the Parent G4 – KEY

Sample Bursting Query for FTP Channel

SELECT ‘ABC’ AS “KEY”
,’Template Name’ TEMPLATE
,’en-US’ LOCALE
,’Text’ OUTPUT_FORMAT
,’FTP’ DEL_CHANNEL
,’OutputFile.txt’ OUTPUT_NAME
,’FTP_CONNECTION’ PARAMETER1
,’/Outbound/’ PARAMETER4
,’OutputFile.txt’ PARAMETER5
,’true’ PARAMETER6
FROM DUAL

Check this for more details : https://docs.oracle.com/cd/E28280_01/bi.1111/e22258/add_burst_def.htm#BIPDM344