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

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 ?
Answers
-
Hello Gamidi,
Please provide more information on which application and which file.
Thank you
Hassan
0 -
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.
0 -
By using BIP Report output type is .CSV File
0