Hello,
I created a chart in a dashboard; I need to know the SQL query behind the reported values in the dashboard. How to see the query?
Thank you in advance.
Jan 07, 2024 06:13 AM
Hi,
If your Cognos is hosted on prem then you could always use SQL Server Profiler to capture what queries are run when a dashboard is run. Otherwise you can only really view the generated SQL when authoring reports in Report Studio and not dashboards (in the dashboard designer).
If the Cognos version is 11.1.7 or later then you could do the following:
regards,
Murray
Jan 07, 2024 04:25 PM
Hi,
1. The Cognos version being used is 11.0.13. I still tried to copy the dashboard, however, nothing is being actually copied, and Cognos is also not indicating that anything has been really copied. Is there any other way to see the generated query for the dashboard in version 11.0.13.
2. Regarding accessing SQL Server Profiler, where exactly could we access the SQL Server Profiler; is it on the Flexera Analytics Server on which Cognos is installed on.
Thank you for your response.
Regards,
Syed
Jan 08, 2024 12:03 AM
Hi Syed,
Cognos 11.0.13 did not allow copy/paste between Dashboard and Reports, so you won't be able to do that. If you (re)construct the same chart manually tho in Report Studio using the same data model you should then be able to look at the generated SQL for the query that is used to animate the chart.
Regarding SQL profiler - that is a component of Microsoft SQL Server not Cognos, so it's typically accessed from a machine that has the SQL Server Mgt Studio (SSMS) installed. If you have access to it you would then start a profiling session connecting to the SQL Server that is hosting the Flexera databases.
Jan 08, 2024 08:45 PM