How to get and SQL for our own OTBI Analysis

Praveen Kumar-146357

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.

SantoshKumarBhairi

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

Praveen Kumar-146357

Thanks Santhosh.It helps..

Christian Berg

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.