Oracle OBIEE report query

user1323905

HI,

I would like to know if there is a way to get the the physical SQL query for a given report.

requirement:

• the query maybe stored in a table in the database (metadata) and can be obtained by running an SQL statement.
• the dashboard report may provide a query ID or SQL_ID or something related.
• I need to be able to run the query in the database so that I can copy the results of the report to another database by clicking on a button or a link inside the report.
• the end-user will choose the query/report filters and the requirement is to export the results of the report to another schema (CSV/excel is not an option).

the closet solution I found is using a SOAP web service to pass the query parameters to ORACLE stored procedure. the PLSQL will build the query using dynamic SQL and the not_null parameters.

it would be easier for me If i can obtain the original SQL statement without having to use web services and PLSQL in a dynamic way.

rmoff

Have a look at SampleApp - pretty sure there's an example on there of showing the Physical SQL for a given analysis. The SQL is stored in S_NQ_DB_ACCT when you have Usage Tracking configured.