hi,
Where We can Find query For Report in Report Studio??? which generate during Report Run-Time...any one tell me please..
Thanks in Advance.
Tools > Show Generated SQL/MDX
Is this what you are looking for?
MF.
I don't know where you'd get that from Cognos, but if I got really stuck, and needed to see the SQL, I'd either turn on ODBC logging at the ODBC datasource level, and get it there, or look at your database logs if you know how to do that.
Good luck ! ;)
Quote from: TheCognosDave on 25 Oct 2013 08:34:00 AM
I don't know where you'd get that from Cognos, but if I got really stuck, and needed to see the SQL, I'd either turn on ODBC logging at the ODBC datasource level, and get it there, or look at your database logs if you know how to do that.
Good luck ! ;)
ODBC is just one type of trace/connection.
If you want to go that route and are using Native drivers then you will need to turn on a UDA trace.
You can also trace the SQL directly at the DB. Also if your using DQM then you will need to enable a DQM trace via XQE.
All depends on what you are using as a data source. ;)
EDIT: You can also trace the SQL via Dispatcher settings to the cogserver.log.
http://www-01.ibm.com/support/docview.wss?uid=swg21370688