8 Replies Latest reply on Jun 9, 2017 9:04 AM by Christian Berg

    12.2.1 view Physical SQL

    Robert Angel

      HI simple question, is there a simple way to view the Physical SQL generated for a single OBIEE report in OBIEE 12.2,1

       

      I have using Logical Sql Diagnostics - does not give me what I need

      I have tried setting logging level and viewing log - ditto

       

      If there is not a way to view the physical sql then is there at least a way to see all of the joins that are generated between the physical tables?

       

      This used to be easy and most useful in 11g!!

       

       

      thanks for your input,

       

      Robert.