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

pepala

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.

Kevin M-Oracle

In the data model on the properties page select

Include Empty Tags for Null Elements

Rgds,

Kevin

RichardChan

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

Could you show your definition as unclear what is happening

pepala

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

pepala

Thank you so much.

Kevin M-Oracle

You are welcome.

Rgds,

Kevin