How We Can Extract Sql From Obiee For Reports?

1.	How We Can Extract Sql From Obiee For Reports?
Answer» There are many ways to extract the sql: Change the request and click Advanced in that you GET xml code and also the actual sql. In the catalog Manager click Tools-CREATE Report . In the Create Report Window –> Click Request SQL and save the sql to the PHYSICAL path in your PC. Enable Loglevel to 2 in the OBIEE 11g Administration Tool from Manage-> Security and enable the log level to 2 by CLICKING properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User. By clcking Administration->Manage sessions-> view sql. There are many ways to extract the sql:

Answer»

There are many ways to extract the sql:

Change the request and click Advanced in that you GET xml code and also the actual sql.
In the catalog Manager click Tools-CREATE Report . In the Create Report Window –> Click Request SQL and save the sql to the PHYSICAL path in your PC.
Enable Loglevel to 2 in the OBIEE 11g Administration Tool from Manage-> Security and enable the log level to 2 by CLICKING properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User.
By clcking Administration->Manage sessions-> view sql.

There are many ways to extract the sql:

Discussion