Skip to content

Oracle Communities

Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Poll: Oracle Analytics Community Website Satisfaction Tell us about your satisfaction with our newly redesigned Oracle Analytics Community Website.

Oracle Fusion ERP Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response

61

Views

6

Comments

erpexpert03

erpexpert03 Rank 1 - Community Starter

Nov 13, 2023 10:11PM in Oracle Fusion ERP Analytics

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?

Tagged:

0

Answers

Renuka Nuguru-Oracle Rank 5 - Community Champion

Nov 14, 2023 12:36AM edited Nov 14, 2023 12:53AM

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.
How to identify employees who haven't created any performance goals and those who have
https://community.oracle.com/customerconnect/discussion/comment/386919#Comment_386919
Summary Looking to create a quick reference report for Division heads to see which employees have created goals and which have notContent
Workers with and without Goals
https://community.oracle.com/customerconnect/discussion/382/workers-with-and-without-goals
Summary This Analysis displays the details of Workers having development goals or without any development goalsContent
Development Goal Report
https://community.oracle.com/customerconnect/discussion/comment/56021#Comment_56021
Content Hello All, I am attempting to create a report that will show me how many employees have how many development goals in process/not started.

Thanks,
Renuka

0
Techie Rank 2 - Community Beginner

Dec 23, 2024 6:38AM

0
Techie Rank 2 - Community Beginner

Dec 23, 2024 6:38AM

0
Techie Rank 2 - Community Beginner

Dec 23, 2024 6:39AM

Any updates on this,?

0
Techie Rank 2 - Community Beginner

Dec 23, 2024 6:39AM

0
Bhaskar Konar Rank 8 - Analytics Strategist

Dec 24, 2024 10:57AM

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

0