Empty column missing from csv output

Antony Hooper-29731

Summary

Empty column missing from csv output

Content

I have a BI Publisher report that extracts several columns that may or may not be populated.  When they are not populated (only null values), the output does not include them when exporting the csv. 

Is there any way to force every column that is specified in the data model to be present in the csv output?

There is a setting for dynamic columns in the report properties under 'FO Processing', however that doesn't seem to be what I'm looking for.

Any help will be appreciated.

Many thanks,

Antony.

Sherry George

You are welcome.

Sherry George

Hi Antony,

Did you try the below option

Antony Hooper-29731

Took me a while to find it, but I knew I'd seen it somewhere, in case anyone else is unsure of where to find this setting:

Yes that's exactly the one, and it also showed me how to remove parameter tags.

Thank you so much, really appreciate it.

Antony.

Max Naluparayil

Hi Antony, Can you please re-upload the image which has the solution to this problem? It shows up as a broken link. 

Rajesh Dhanapal

Hi,

Please can you re-upload the image. I have got exactly the same issue.

Harishma

Hi @Antony Hooper-29731, could you please re-share the image? I am dealing with the same issue and would like to understand the solution.

Harishma

Hi @Sherry George, could you please re-share the solution that was provided? I don't see the solution/image in this thread. I am dealing with the same issue and would like to understand the solution.

Gianni Ceresa

Both users aren't active in this forum. This question was imported from another platform.

Please post a new question in https://community.oracle.com/products/oracleanalytics/categories/bi-publisher , post your product name and version and your question with all the details for other people to be able to provide replies.