Hi

I would like to check the log of executed report generated SQL instead of checking directly from "show generated SQL/MDX" from report studio designer. Could anyone share me where can I check this log? My report data package used CQM model and version is 10.2.1.
My objective is to try to run that SQL in sql developer directly to check some performance issue.

Thanks and Regards

------------------------------
Wai Wai Data Engineer
------------------------------

#CognosAnalyticswithWatson

It can be easily set in Administration Console, look for property called "Generate comments in native SQL".
These online documents describe some background details:

1. How to see which user is generating a query in Cognos Analytics
2. Setting query service properties

Best regards

#CognosAnalyticswithWatson

Thanks Gertrud for sharing info.

------------------------------
Hnin Sept Data Engineer
------------------------------

Original Message:
Sent: Mon February 24, 2020 04:24 AM
From: Gertrud Lohwasser
Subject: Log to check executed cognos reports underlying SQL

It can be easily set in Administration Console, look for property called "Generate comments in native SQL".
These online documents describe some background details:

1. How to see which user is generating a query in Cognos Analytics
2. Setting query service properties

Best regards

------------------------------
Gertrud Lohwasser
------------------------------

The correct way to see the SQL that a report will execute is to use the Validate action set to information level or key-transformations.

Showing SQL as you noted, may be a good clue, but does not convey the query which is planned based on the data containers (layouts) that define how a result is to be "shaped".  

Further, the key-transformations option will show you where query re-use may be applied or not etc.

------------------------------
NIGEL CAMPBELL
------------------------------

Thanks NIGEL for sharing.

------------------------------
Hnin Sept Data Engineer
------------------------------

Original Message:
Sent: Mon February 24, 2020 07:55 AM
From: NIGEL CAMPBELL
Subject: Log to check executed cognos reports underlying SQL

The correct way to see the SQL that a report will execute is to use the Validate action set to information level or key-transformations.

Showing SQL as you noted, may be a good clue, but does not convey the query which is planned based on the data containers (layouts) that define how a result is to be "shaped".  

Further, the key-transformations option will show you where query re-use may be applied or not etc.

------------------------------
NIGEL CAMPBELL
------------------------------