Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
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.
Best Answer
-
In the data model on the properties page select
Include Empty Tags for Null Elements
Rgds,
Kevin
1
Answers
-
That is a bit strange so you are missing pipe separators?
Could you show your definition as unclear what is happening
0 -
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
0 -
Thank you so much.
0 -
You are welcome.
Rgds,
Kevin
0
