Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Semi Joins in OBIEE

Received Response
11
Views
3
Comments
Martin van Donselaar
Martin van Donselaar Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

Hi All,

Is it possible to use Semi Joins in an Obiee Answer Report?

What i want in pseudo code is: Select <something> From <Starmodel> Where Not Exist <Correlated Subquery>

I know it is possible to do direct SQL but that is not what i'm looking for.

TIA

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

    pastedImage_0.png

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics & AI Lead

    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.

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics & AI Lead

    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.