Categories
BI Publisher empty column missing from csv output
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
Answers
-
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
0 -
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.
0 -
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 XMLInclude Parameter Tags: Disable to ensure DM parameters are not added as column in CSV and XML0 -
Check if this helps:
- 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)
0
