Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Query => Topic started by: tominboston on 13 Oct 2005 07:50:14 PM

Title: Ugh How do ya get the sql out of a thousand reports?
Post by: tominboston on 13 Oct 2005 07:50:14 PM
 
Anyone know if it is possible to extract the sql for all reports in Cognos Query?
(that is, for each published report in everyone's NewBox, how does one -automatically- compile the sql for each ?)

Very much appreciate any insights any guru may have!!!!!!!!!!
Title: Re: Ugh How do ya get the sql out of a thousand reports?
Post by: TheCognosDave on 18 Oct 2013 03:17:04 PM
Easy peasy .. it's stored in the Cognos database as XML.  Just query the tables and parse XML for the Queries ;)
Title: Re: Ugh How do ya get the sql out of a thousand reports?
Post by: MFGF on 21 Oct 2013 05:09:44 AM
Quote from: tominboston on 13 Oct 2005 07:50:14 PM

Anyone know if it is possible to extract the sql for all reports in Cognos Query?
(that is, for each published report in everyone's NewBox, how does one -automatically- compile the sql for each ?)

Very much appreciate any insights any guru may have!!!!!!!!!!

It depends - is this really Cognos Query (ie the old Series 7 web ad-hoc report authoring tool) or are you using ReportNet / Cognos 8 / Cognos 10?

MF.
Text only | Text with Images