Wsrtjtyk

We are using obiee 11g.

In my repository (RPD), I have joined two tables with a left outer join (specifically, the Person table left join the address table).

In my analyses, I take some info of the person and some info of the address. I make a filter on the female persons and I get all female persons, even if they have no address.

But, I only want to see the address types 'HOME', so I thought to put in my analyses a filter on addressType='HOME' OR addressType is null. Unfortunately, I don't get all the female persons anymore. I only get the female persons with an address type HOME.

When I look at the generated query, I see:

select person.emplid,addr.address_type,addr.address3 from 

person

LEFT JOIN address addr

on person.emplid=addr.emplid

WHERE person.sex='female'

        AND ( address_type IN ('HOME')

                OR

              address_type IS NULL)

I see that the address_type filter is put in the WHERE clause, but here I want it to be set in the ON clause of the LEFT JOIN like this:

select person.emplid,addr.address_type,addr.address3 from 

person

LEFT JOIN address addr

on person.emplid=addr.emplid

AND ( address_type IN ('HOME')

                OR

              address_type IS NULL)

WHERE person.sex='female'

If it is like this, it works, but I don't know how to force this in my analysis. Can someone help me?