Checking query for OTBI / Analysis report

 Hi

Let us quickly check how to query for Subject area report or OTBI Or Analysis report.

After creating subject area report, please use following steps to find the query

Step 1: Go to your login in Reports and Analytics page

Step 2: Click on "Administration"

Step 3: Click on "Manage Sessions"

Step 4: In the Manage Sessions page, 

check records with your user login.

if you are finding multiple records, click on "Close All cursors". Now got to your subject area report and click on Results. Now refresh this Manage Sessions to see only active records.

Click on "View Log" 

For more confirmation i.e.,  whether your checking accurate report. Check columns of the subject area report in Statement Column

Step 5: Similar page appears after clicking on View Log.

Search for "With"

After searching for "With" clause

Step 5: From starting of "With" clause  to rownum<=75000 is the query of the Analysis.