Oracle Analytics and AI

User_JNBDB

Hello Team,

How to generate a BI Publisher report (scheduled through ESS Job) with headings only (without 1st line with delimiters) when there is no data in CSV format?

Note: Not by using bursting method.

Thank you

User_V2YGS

Here is just one method:::::

To ensure your scheduled BI Publisher report outputs only the column headers (without an empty row of delimiters) when the dataset is empty, you can handle this directly in your template layout.

Since you aren't using bursting, here are the two most effective methods depending on your template type:

Method 1: If Using an eText Template (.etx)

If you are using an eText template to generate your CSV file, you need to conditionally wrap only the data record section so it doesn't execute when the group is empty, while leaving the header section untouched.

1. In your eText setup table, keep your header record row defined as usual.
2. For your data record block, use a standard IF condition or an empty check around the data group loop.
3. Wrap your data group inside a check like:
   • Start command: Group_Name
   • Condition: count(ELEMENT_NAME) > 0
4. If the count is 0, BI Publisher will process the header record normally but completely skip the data record section, preventing any trailing empty lines or rogue delimiters from generating.