Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 191 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 66 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
