Implement antijoin in OBIEE

3263470

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

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

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