Identify repeating reports

[rkeshava]

Hello experts - Do we know of a Cognos SDK application/tool that would look at various reports (SQL for instance) and determine that Report A, B, C for example are all asking for the same information or a Report A is collecting a superset of the information that Reports B, C contains. Thanks in advance. HKR

[FM]

A report is basically just an xml. All you need to do, is compare them.

For example, how many reports are exactly the same save for the formatting? How many reports have similar, if now identical sql statements?

It's simple xpath... I don't know how many report authors you have, but the more you have, the greater the chance for repeating reports, and the chance for loss of knowledge.

A simple program can extract for you anything you want from the report. How many queries it has, query names, column names, expression values, datasource names, sql text and so on. It's all up to you...

Is there something built already that does it, not sure. But it's basic c# and a little xpath. :)

[xiska]

Hi

FM's way is good and right and probably the only one.
Little xpath?!? Yes - may be.

I would also turn on the cmtrace for a while which writes all native sql queries to the /logs/cmtrace.log.

Have fun.