Include a column in an out of the box analysis when null

erpexpert03

I would like to use an analysis in OTBI but include the data when a column has a null value. What happens now is when I add the column and that column is null, the results are filtered out. I would like to use this analysis to identify when the column is null. Is there a way to do this without having to customize through BIP?

Renuka Nuguru-Oracle

Hello,

Can you provide the report requirement, so that we can look into the options.

I would recommend you to go through below given links, so that you can create your own report with the help of below given report design logic from the community links.

https://community.oracle.com/customerconnect/discussion/comment/386919#Comment_386919

https://community.oracle.com/customerconnect/discussion/382/workers-with-and-without-goals

https://community.oracle.com/customerconnect/discussion/comment/56021#Comment_56021

Thanks,

Renuka

Techie

Techie

Techie

Any updates on this,?

Techie

Bhaskar Konar

Hi @Techie,

What is your issue / requirement? Can you please provide the details so that it can be looked accordingly.

Cheers,