There are many ways to get the SQL from OBIEE Reports
- Modify 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 Admin Tool from Mange -> 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 clicking Administration ->Manage sessions -> View SQL