Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
204
Views
3
Comments
Gamidi Venkat Rambabu
Gamidi Venkat Rambabu Rank 2 - Community Beginner

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

  • Hassan El Bouihi-Oracle
    Hassan El Bouihi-Oracle Rank 5 - Community Champion

    Hello Gamidi,

    Please provide more information on which application and which file.

    Thank you

    Hassan

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    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
    Gamidi Venkat Rambabu Rank 2 - Community Beginner

    By using BIP Report output type is .CSV File