Implement antijoin in OBIEE

3263470 · Apr 23, 2018 3:26PM

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

Gianni Ceresa · Apr 23, 2018 3:31PM

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 · Apr 24, 2018 3:55AM

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).

MFA for Oracle Community