Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

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

Comments

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…

in Analysis based on Direct Database Query Comment by Ashish Shah-Oracle Nov 12, 2020 2:23AM
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

in Analysis based on Direct Database Query Comment by Ashish Shah-Oracle Sep 10, 2017 10:18AM
Sorry forgot to attach.

in Analysis based on Direct Database Query Comment by Ashish Shah-Oracle Dec 7, 2016 11:02PM
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

in Analysis based on Direct Database Query Comment by Ashish Shah-Oracle Dec 7, 2016 11:02PM
Hi All, Please refer below idea before putting in efforts into this. https://cloudcustomerconnect.oracle.com/posts/51c4d1c58e Regards, Ashish

in create analysis from direct db query Comment by Ashish Shah-Oracle Jan 23, 2018 6:07AM