FTP Files of BI Publisher Report Via Bursting > Defining The Bursting Query

Summary:

FTP Files of BI Publisher Report Via Bursting > Defining The Bursting Query

Content (required):

Hello All,

We would like to send a report generated in CSV format to a FTP Server. The Data Model and BIP report are defined – PFA screenshots

On https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T555155.htm (Adding Bursting Definitions), it is mentioned that the delivery and formatting preferences should be contained in a database table. In our case, the delivery is FTP and the format is CSV and it is not in a database table.

Do you have any advice how to define the bursting query? On the same link above, it is mentioned we may consider creating a table, but how? Any advice is appreciated