If you are using 11.1.5, you can do it two ways.
1. Select the query subject and click on the show query information context menu item.
2. Press the try it button, go into report studio, drag the query subject into the list and view the show generated sql.
If you are using 11.1.4 or earlier you can only do it using method number 2.
------------------------------
IAN HENDERSON
------------------------------
Original Message:
Sent: Wed January 22, 2020 01:43 PM
From: Buddhi Gupta
Subject: Cognos Data Module SQLs
Is there any way to get SQLs from Cognos data modules? When we create Custom Tables, want to know it's sql behind it like FM.
Thanks!
------------------------------
Buddhi Gupta
------------------------------
#CognosAnalyticswithWatson