Empty column missing from csv output

Question

Hi All,

When the CSV file format report is generated , the output does not show the columns having null values

eg:

Below columns to be displayed in .csv report

col1 -10

col2-20

col3- 30

col4- null

col5- null

csv output file generated only with the columns having the below values.

col1, col2,col3

10,20,30

NOTE : Col4, col5 are not appearing.

RRoshan -Oracle · Accepted Answer

Got the information on this

Fusion BI Publisher Report Columns Missing When Exporting To CSV (Doc ID 2177002.1)

Prateek Mohan · Accepted Answer

In the Data Model Properties, ensure :

Include Empty Tags for Null Elements    : Enable to ensure if a column is fully NULL in report, it still shows up in CSV and XML

Include Parameter Tags   : Disable to ensure DM parameters are not added as column in CSV and XML