Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Dynamic Cubes => Topic started by: Cognos8 on 31 Aug 2015 10:08:20 AM

Title: Dynamic cube SQL Generation
Post by: Cognos8 on 31 Aug 2015 10:08:20 AM
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.
Title: Re: Dynamic cube SQL Generation
Post by: MFGF on 01 Sep 2015 04:51:34 AM
Quote from: Cognos8 on 31 Aug 2015 10:08:20 AM
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.
Title: Re: Dynamic cube SQL Generation
Post by: bus_pass_man on 01 Sep 2015 07:03:35 PM
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.
Text only | Text with Images