General OBIEE

Get Involved. Join the Conversation.


    Praveen Kumar
    How to get and SQL for our own OTBI AnalysisAnswered
    Topic posted May 15, 2019 by Praveen KumarRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, BI Publisher Report Templates, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, OTBI, SQL 
    163 Views, 3 Comments
    How to get and SQL for our own OTBI Analysis
    SQL for OTBI Analysis

    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.


    Praveen G.

    Best Comment

    Praveen Kumar

    Thanks Santhosh.It helps..



    • Santosh Kumar Bhairi

      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.



    • Christian Berg


      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.