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

erpexpert03 · Nov 13, 2023 10:11PM

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 · Nov 14, 2023 12:36AM

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