My Oracle Support Banner

How To Apply Filter On Dimensions With An Outer Join In Oracle Analytics? (Doc ID 2712051.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

Oracle Analytics Cloud - Version 18.3.3 to 105.8.0 [Release 18 to 105.3]
Oracle Analytics Cloud - Classic - Version 18.3.3 to 105.8.0 [Release 18 to 105.3]
Oracle Analytics Server - Version 5.5.0 to 5.5.0.20080828 [Release 5]
Information in this document applies to any platform.

Goal

How do we accomplish the following Requirement with the RPD modeling?
Two dimensions are joined using an outer join. A filter needs to be added on the resulting rows so that the outer join does not fetch all rows. Applying a filter on analysis or in the BMM layer causes the filter condition to be added in the "WHERE" clause of the generated query (as physical SQL is generated in ANSI syntax).
Here is a sample of Actual SQL generated with Dept and Emp tables. Observe the filter condition appended as part of "WHERE" clause:

 

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
References


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