If you are unable to create a new account, please email bspsoftware@techdata.com

« previous next »
Pages: [1]

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

tominboston

  • Guest
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!!!!!!!!!!
Logged

TheCognosDave

  • Guest
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 ;)
Logged

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,643
  • Forum Citizenship: +676/-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 »
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.
Logged
Meep!
Pages: [1]
« previous next »
 

BSP Software Articles
Populating Framework Manager Descriptions from SQL Server Extended Properties
Performance Monitoring in MetaManager™

BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel TD SYNNEX
Security Migration Twitter - TD SYNNEX IBM Cognos
Integrated Management Suite ExitCertified - Cognos Training