How to give left outer join with "LIKE operator" in obiee 11g RPD?

Question

Hi,

I am working on obiee 11g.

When i am creating RPD, i have to give left outer join with LIKE Operator..

My tables are W_LD_REPAY_D,W_CONTRACT_STATIC_D

For example,mappping is as follow

LEFT JOIN : W_LD_REPAY_D.ID  LIKE W_CONTRACT_STATIC_D.CONTRACT_CODE||'%'

I dont know, How to give above join in RPD?

Please help me,

Thanks in advance,

A.kavya

891582 · Answer

yes you are able to give join like operator in physical layer you can't define left outer join in physical layer , you define left outer join in BMM