Oracle Communities

Oracle Analytics and AI

Child Item

Empty columns missing from BI Publisher output in oracle fusion report and analytics

I have developed BIP report with around 60 columns in my query and generated pipe (|) delimited output. However, my output shows only columns which has data and missing all other columns which does not have any data. My requirement is to include each and every column in the output whether the data exists or not.

Really appreciate your help.

Find more posts tagged with

Accepted answers

In the data model on the properties page select

Include Empty Tags for Null Elements

Rgds,

Kevin

All comments

That is a bit strange so you are missing pipe separators?

Could you show your definition as unclear what is happening

my query is like this with empty columns

select invoice_number,

invoice_date,

NULL custom_column1,

NULL custom_column2,

invoice_amout

from ap_invoices_all

In the output custom_column1,custom_column2 are not coming but I want these columns as party of my output.

Thanks

In the data model on the properties page select

Include Empty Tags for Null Elements

Rgds,

Kevin

Thank you so much.

You are welcome.

Rgds,

Kevin