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 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)
Fusion BI Publisher - Output to .csv Files sometimes Switches/incorrect Column Order (Doc ID 1968541.1)

Thanks.

Prateek Mohan

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

Riyaz Ali-Oracle

Check if this helps:

1. Modify the Data Model:

Ensure that all columns are explicitly included in the SQL query.
Use NVL(column_name, ' ') or COALESCE(column_name, ' ') to replace null values with a placeholder (such as a space or default text).

2. Enable "Include Empty Tags" in BI Publisher

Navigate to the Report Properties.
Enable the option "Include Empty Tags for Null Elements" to ensure that empty columns are retained in the output.

3. Adjust CSV Output Properties

Go to Report Processing and Output Document Properties.
Modify the CSV Output Properties to ensure all columns are included.

Check the below:

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

10 Setting Report Processing and Output Document Properties