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

Implement antijoin in OBIEE

Received Response
7
Views
2
Comments
3263470
3263470 Rank 2 - Community Beginner
edited Aug 13, 2024 5:50PM in Oracle Analytics Cloud and Server

I have data in 2 tables and need to implement antijoin between them in OBIEE11/12c. Please suggest how should I model my repository.

Thanks

Viresh

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    You can try with table1 left outer join table2 and a condition to keep only rows where table1.column is null .

    That's one of the way to do it in SQL and you can do it in the LTS.

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

    Is this something you need for just one or few analyses?

    If so you may also consider to use sub-queries in your analyses instead of fixing it in your model (which shouldn't be overly complex IMO).