My Oracle Support Banner

OBIEE 12C: How To Create a Filtered Join Statement When Creating an Analysis (Doc ID 2694298.1)

Last updated on FEBRUARY 25, 2022

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Goal

How to create an analysis in OBIEE 12c that includes records from a table that is joined by a left outer join.
The known workaround is to create a VIEW in the Oracle database that does this filtering but is there any other way to avoid following this practice for every table that requires additional filtering.
How to achieve this ? 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.