Dynamic cube SQL Generation

[Cognos8]

I have created report using Dynamic cubes, How can i find the generated SQL ? Below steps are correct ? How can i find the user specific executed SQL?


1) Locate the following file in your Cognos installation directory
For Cognos 10.1.1 or earlier: c10\configuration\xqe.config.xml
For Cognos 10.2 or later : c10\configuration\xqe.diagnosticlogging.xml

2) Open it in an editor.

3) Search for the section <component name="XQE">

4) In that section look for <eventGroup name="JDBC"/>

5) Change it to <eventGroup name="JDBC" level="info"/>

6) From Cognos Administration restart the Query services. Please make sure the correct Java process disappears in Task Manager. If you are unsure restart the complete Service from Cognos Configuration.

[MFGF]

I have created report using Dynamic cubes, How can i find the generated SQL ? Below steps are correct ? How can i find the user specific executed SQL?


1) Locate the following file in your Cognos installation directory
For Cognos 10.1.1 or earlier: c10\configuration\xqe.config.xml
For Cognos 10.2 or later : c10\configuration\xqe.diagnosticlogging.xml

2) Open it in an editor.

3) Search for the section <component name="XQE">

4) In that section look for <eventGroup name="JDBC"/>

5) Change it to <eventGroup name="JDBC" level="info"/>

6) From Cognos Administration restart the Query services. Please make sure the correct Java process disappears in Task Manager. If you are unsure restart the complete Service from Cognos Configuration.

Hi,

If you read the below article, it indicates that the DQM Server log is written to <Cognos install location>\logs\XQE\xqelog-<timestamp>.xml

http://www-01.ibm.com/support/docview.wss?uid=swg21666867

I'd be looking here if I was you :)

Cheers!

MF.

[bus_pass_man]

You might want to be aware of this article too.
https://www.ibm.com/developerworks/library/ba-pp-infrastructure-cognos_specific-page655/

Learning the dynamic query analyzer might also be useful.
Here's an article about it. 
http://www.ibm.com/developerworks/data/library/cognos/infrastructure/cognos_specific/page578.html
plus there's stuff in the redbook optimization

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.0/com.ibm.swg.ba.cognos.ug_cog_rlp.10.2.0.doc/t_configsettings.html%23ConfigSettings

Most of this is designed for query optimization.