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

ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD

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

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