Semi Joins in OBIEE

Question

Hi All, Is it possible to use Semi Joins in an Obiee Answer Report? What i want in pseudo code is: Select From Where Not Exist I know it is possible to do direct SQL but that is not what i'm looking for. TIA

Martin van Donselaar · Answer

I suppose I should have searched the forum first because this has already been answerred:  .

This describes to rewrite the query using a outer join.

Still, I think a NOT EXIST makes more sence semantically so I would prefer to use that approach if possible.

Martin van Donselaar · Answer

Thanks Christian,

I have looked into that but I think that way you will be able to do NOT IN subqueries but I don't see how to do NOT EXIST from there.

[Deleted User] · Answer

Depending on what you actually mean with this you may want to look at the filter option: Filter based on another analysis