How To Apply Filter On Dimensions With An Outer Join In Oracle Analytics?
(Doc ID 2712051.1)
Last updated on SEPTEMBER 22, 2020
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 18.104.22.16880828 [Release 5]
Information in this document applies to any platform.
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:
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