General OBIEE

Get Involved. Join the Conversation.

Topic

    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 
    158 Views, 3 Comments
    Title:
    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.

    Best Comment

    Praveen Kumar

    Thanks Santhosh.It helps..

    Comment

     

    • 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.

      thanks,

      Santosh

    • 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.