Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to implement NOT EXISTS functionality in OBIEE 12c

3427576Mar 9 2018 — edited Mar 10 2018

Hi Experts,

I am using "CREATE DIRECT DATABASE QUERY" option from OBIEE 12c to meet my requirement.

My requirement : I need to identify the customers who bought product X1 from product X category and not bought product Y1 from product Y category.

The data of Product X1 and product Y1 is available in the same column called Product

The data of Product X category and product Y category is available in the same column called Product Group

Now, I would like to find out how the same requirement (NOT EXISITS) could be met through RPD modelling or OBIEE Analytics.

Please advise!!

Thanks in Advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2018
Added on Mar 9 2018
#business-intelligence-applications
5 comments
975 views