Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What reports use a particular table or column?

Status
Not open for further replies.

rsx

Programmer
Dec 12, 2002
28
CA
Hello

Is there a way to find out what web reports use a particular table?

Thanks.

 
8.4 has data lineage, which gives a sort of executeplan based on the modelling in Cognos. This can be more or less exact concerning tables accessed, depending on the model.

A more exact approach would be to start a database trace, run the report(s) and find out which tables are read. all of this requires quite a lot of manual effort..

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top