1 Reply Latest reply: Mar 26, 2015 5:32 PM by Massimo Grossi RSS

    Intercept SQL code generated by QV server

      Working with Oracle platform I was able to execute an OBIEE report or dashboard and then intercept the pure SQL that BI server generated before sending it to Data Server (Oracle DB). As Admin of OBIEE I was able to monitor active session and then choose a drill down into session data which contained SQL code.

       

      Is the above functionality available with QV?

       

      I am not talking here about the SQL code that is exposed through the loader from the QVD file. In QVD each portion of SQL code represents a data set. I believe when I create a dashboard and use some filtering conditions then the datasets from QVDs are joined and the WHERE clause is generated dynamically using the values of filtering parameters. I need to see this generated SQL code.

       

      Thanks,

      Marek