BI Publisher empty column missing from csv output

Claudio De Castiglioni

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. 

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

Many thanks,
Claudio

Mallikarjuna Kuppauru-Oracle

Hi @Claudio De Castiglioni,

This is expected behavior.

When exporting in CSV, when there is no data in the column, the column is not displayed.

To view the column, check the data sets properties and for the column in question check Value If Null property.

You can also add a default value to this column in Data model > Structure > Value if null for this column as workaround.

Regards,

Arjun

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/23912/bi-publisher-empty-column-missing-from-csv-output

This is the expected behavior as per Oracle official MOS note:

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

Fusion BI Publisher - Output to .csv Files sometimes Switches/incorrect Column Order (Doc ID 1968541.1)

Thanks.