Busting OTBI Myths - NOT IN

Content

Myth: OTBI can't give me a list of workers without goals (or absences or ...)

There are a few ways to perform a "NOT IN" query.  The easiest and most performant is to use the MINUS SET operator, listing all workers MINUS those with goals.  Another simple solution is to filter one analysis (all workers) based on the results of another (NOT IN workers with goals), however, this only works well when the data sets are not large.  A more complex solution is to use Logical SQL

Examples in Report Sharing Center:

• https/cloudcustomerconnect.oracle.com/posts/916d8357fb (SET and NOT IN)