Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
1
Comments
ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD
ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD Rank 5 - Community Champion
edited Aug 13, 2024 7:09PM in Oracle Analytics Forum

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

Answers

  • 891582
    891582 Rank 1 - Community Starter

    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