Author Topic: Ugh How do ya get the sql out of a thousand reports?  (Read 8949 times)

Offline tominboston

  • Full Member
  • ***
  • Join Date: Oct 2005
  • Posts: 7
  • Forum Citizenship: +1/-1
Ugh How do ya get the sql out of a thousand reports?
« 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!!!!!!!!!!

Offline TheCognosDave

  • Full Member
  • ***
  • Join Date: Sep 2013
  • Posts: 33
  • Forum Citizenship: +2/-0
Re: Ugh How do ya get the sql out of a thousand reports?
« Reply #1 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 ;)

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,331
  • Forum Citizenship: +623/-10
  • Cognos Software Muppet
Re: Ugh How do ya get the sql out of a thousand reports?
« Reply #2 on: 21 Oct 2013 05:09:44 am »

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.
Meep!

 


       
Twittear