ETL, App Development and other tools > Automation

Data Dictionary and Compilation of Reports

(1/3) > >>

tominboston:
 ???
Does anyone know how to extract the sql from several thousand Cognos Query reports published to Upfront?
I need to compile a list of reports and their sql.

Help!
Much thanks!

dwood09:
Does Cognos Query support Automation?!  If it does have an object model, then it should be possible to extract these details.  It is certainly possible to traverse the items of upfront.

cheers,
DW

tominboston:
Man I am stuck on this one ... thanks for the input dwood,
but I don't know how I can get a user friendly view of the datastore/object store ... I can suck out a list of reports from the CQPackage.pkg but the sql is all crapped out .... (eg):
"... N_0aoBETWEEN_0aoNOT_20BETWEEN_0aoIS_0aoIS_20NOT_0an_0a0_0a0_0aClient_20Id_0aarial_2c_20geneva_2c_20helvetica_2c_20sans_2dserif_0a2_0a0_0a8_0accccff_0aarial_2c_20gen "

Any ideas?

(I'll have to buy you a beer if you can figure this out ...)

dwood09:
Check out the Doco for Cognos Query.  Does it mention anything about macros, object model, automation, batch processing etc?

cheers,
DW

tominboston:
Nada my friend ... just nada ....  :-[

Navigation

[0] Message Index

[#] Next page