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