InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Get Sql From Obiee For Reports? |
|
Answer» There are many ways to get the sql Modify the request and click ADVANCED in that you get xml code and 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 clcking Administration->Manage SESSIONS-> view sql There are many ways to get the sql Modify the request and click Advanced in that you get xml code and 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 clcking Administration->Manage sessions-> view sql |
|