Oracle Transactional Business Intelligence

How to get and SQL for our own OTBI Analysis
Summary
SQL for OTBI Analysis
Content
Hi All,
How to get and SQL for our own OTBI Analysis.I know we can get this in the advanced tab but there we cannot see the sub query and all.
Where to get the SQL including sub query.Also help me with the navigation.
Thanks in Advance.
Regards,
Praveen G.
Answers
-
hi Praveen, you can navigate to 'Administration' (on the top menu header), Manage Sessions and there you will find sessions for each execution. You can search the session log either by Report Name or User. It provides a very detailed session log which includes the physical SQL as well.
thanks,
Santosh
-
Thanks Santhosh.It helps..
-
Praveen,
In the spirit of fairness and to actually help other users - your answer wasn't "correct". It was Santosh's and that one should be marked in order to appear as "Correct" and in green.