Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to get and SQL for our own OTBI Analysis

Received Response
82
Views
3
Comments

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    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

  • Rank 1 - Community Starter

    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.

Welcome!

It looks like you're new here. Sign in or register to get started.