Dear Ling, This feature really does wonder. We can create report using BIP as well but OTBI is very power in terms of look and feel. In BIP we cannot have same look & feel as in OTBI. Additionally, in BIP we generally tend to write different sql for different view but same data. E.g. summary vs detailed whereas in OTBI…

Hi, Please refer following document on Oracle Support portal. How To Create A Report with Direct Database Query in OTBI/OBIEE Analysis, Who Can Access Direct Database Query (Doc ID 2141412.1) Regards. Ashish

Sorry forgot to attach.

Dear Ling, Please find attached. You might have to reattach all analysis. Also let me know in case you want to discuss. I can set up a small meeting with you and walk you through. Thanks Regards, Ashish Shah

Hi All, Please refer below idea before putting in efforts into this. https://cloudcustomerconnect.oracle.com/posts/51c4d1c58e Regards, Ashish