Sorry for being late @Gianni Ceresa , I have made it by applying at... expanding the source of the table->properties->content tab->where condition.. Thanks for helping and enlightening me on complex joins. but anyhow my leads are not recommending to use complex join, so .. moved to above approach. thanks again. Santhosh S.

sorry to mention as BMM @Gianni Ceresa , I have went to Physical diagram->Expression Builder-Phyiscal join.. there when I am typing as status='Y' it is showing error.. Can you please help me on where to go and write the condition?

Thanks for the Quick reply @Gianni Ceresa , I have opened the Expression builder from BMM layer join. but where exactly I need to write the condition.? I could see only expression field inside builder.

Thanks for the reply @rmoff , I was reading your blogs from two days regarding performance tuning like, Performance and OBIEE - part VII - Optimising OBIEE performance ("Tuning") - Rittman Mead Consulting and Performance and OBIEE - part VI - Analysing results - Rittman Mead Consulting . yes we have been facing the issue…

thanks for the reply, Can you advice any other approaches rather than this please.