Unable to get header column in csv output file if there is no data ?

Gamidi Venkat Rambabu

We have requirement where we need to move the file to server . when there is no data in the file. we are unable to getting header column ?

Hassan El Bouihi-Oracle

Hello Gamidi,

Please provide more information on which application and which file.

Thank you

Hassan

Nathan CCC

Hi Gamidi,

No need to provide extra information. This is a frequently asked question. Yes if you build a data model which returns no data found when you execute the report in OTBI then yes the output format as CSV is empty without even a line 1 with the column headers. You do not even get a file if you are using bursting.

A workaround is to add a data set for example G_0 to your data model with "select all lower('x') as S_KEY from dual". Then add a column with constant value "x" alias "KEY" into your existing main query G_1. The create a link from parent G_0 to child G_1 on column S_KEY = KEY. Now you will always get at least 1 empty row in your output CSV with the headers.

Gamidi Venkat Rambabu

By using BIP Report output type is .CSV File