Thursday 17 January 2013

How to get SQL from OBIEE Reports?

There are many ways to get the SQL from OBIEE Reports
  1. Modify the request and click Advanced in that you get xml code and also the actual SQL.
  2. 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.
  3. 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.
  4. By clicking Administration ->Manage sessions -> View SQL

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis