I need to generate trace files to capture the query execution against database when OBIEE reports are executed from dashboards.
I have enabled SQL net tracing and when I try to connect to database from OBIEE server and execute some queries , I see that trace files are being generated.
But when I execute reports from dashboards , no trace files are being generated.
I am probably missing something. Can you please help guide how to ensure trace files are being generated for report queries executed from OBIEE dashboards.
Maybe it is just going to the cache only and not hitting the DB. Try clearing/disabling the beforehand.