How to Get the Underlying Query of a OTBI or Analysis Report?

When connecting to an OTBI or an Analysis Report, there are some scenarios where the users want to see the underlying query and the filters applied.

This article would walk you through the steps to get the underlying query:

1. Log in to your Oracle Fusion, click on the burger menu in the top left, and navigate as follows:
   Tools -> Reports and Analytics -> Browse Catalog
   
   Note: FDI, OBIEE, OAC, OAS users can simply log in to the /analytics URL
   
   
2. Click on the Catalog in the top right, and navigate through the folders to the OTBI or Analysis report for which you want to see the underlying query.
   
   
3. Click on Edit on the OTBI report.
   
   
4. Click on the Advanced Tab on the top left.
   
   
5. The SQL Issued section would have the underlying query of that report.
   
   You can copy all the contents in the SQL Issued box and paste it on a notepad to conveniently view the query on a larger screen.