I have a report on Cognos Analytics 11.1, with prompt pages. When I run the report
I want to see/find the query which is executed on oracle DB
with the prompt values that I am passing through.
Do you know If there is a log file , which keeps this info.
Maybe use the property Generated SQL to view the query
For Cognos 11
From query explorer. Select the query and change the property Use SQL Parameters to Literal
Next, Ctrl + Alt + M will reveal the menu options at the top for -- File, Edit, View
Select Tools
Then choose Show generated SQL/MDX