Generate SQL query using Oracle tables when the OTBI subject area is part of the BI Publisher DM

Question

We have a BI Publisher report. The current report data model includes:

* one dataset based on an OTBI subject area
* other datasets based on Oracle standard tables

We need Oracle’s help to obtain the complete query from Administration > Manage Sessions and identify the equivalent query using only Oracle standard tables.

Our objective is to replace the OTBI-based dataset with a dataset built entirely on Oracle standard tables, while preserving the same report output and logic used in the current BIP report.

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/77495#Comment_77495

Thanks for clarifying. I have moved it to the correct location now.

Guthi Mallikarjun · Answer

Hi Mandeep,

Thank you for asking. We need a solution for the requirement mentioned above and are currently checking its feasibility.

Thanks,

MandeepGupta · Answer

Hi Guthi,

Welcome to Oracle Analytics and AI community.

Is this an enhancement request that you are requesting?

Thanks,