COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: richard@AA on 07 Jun 2019 10:03:54 AM

Title: Generate one reports SQL from another report
Post by: richard@AA on 07 Jun 2019 10:03:54 AM
We have a number of reports that fall under SOX auditing. One of the things the auditors want is the SQL for each report. Currently we have to open each report, go to the queries and generate the SQL. This is a slow process. What we would like is to have a report that can generate the SQL (either individual queries or the whole report) for these SOX reports. Any ideas?

thanks!