I have view derived from 2 facts f1&f2 say WIP_v and the view is joined with f1 ( with 4 joins b/n them - complex join) in Physical Layer. In BMM layer WIP_v and f1 is having inner join. Now the issue is user want to see all the data from WIP_v ( though it is null he want to see ). Hence modifed join from Inner to RightOuter in BMM layer between WIP_V and f1. After giving right outer join getting " Table or View doesn't exit error. Checked the backend query, it is bringing in Login_party and few tables which I was never joined with f1.
Option 1 : Tried creating new LTS for F1 and brought WIP_V under General tab and tried giving Outerjoin between WIP_V and F1, it is not throwing any error but all values from WIP_v is not getting displayed.
Ex: Ordernum Order amount WIP_v_column
123 3456 Y or N
As of now when I create above report gives no results page if I user option1.
But if query only 2 columns without WIP_V column and I am getting results Ex: Ordernum Order amount
Repository is being used by many people. Report is working fine if I give Inner join between WIP_V fiew and fact1. Only if give Right outer join between them, then it is throwing table view doesnot exit.