[SOLVED] List of which reports use which data source

[kc9400]

Hi,

Just wondering if there is a simple way to find out which reports are using which data source without having to manually go into each report. With the number of reports we have this would take some time.

Looks like I'm set to have quite the clean up job.....

[MFGF]

I'm thinking this is something you could do with Metamanager? It's worth dropping a line to one of the BSP guys to see.

Cheers!

MF.

[jnovay@bspsoftware.com]

BSP software does have the functionality you are looking for.  Feel free to shoot me an email at jnovay@bspsoftware.com if you would like to discuss.

John

[Grim]

Also SDK...

Here's something close (by package not DS).
http://www-01.ibm.com/support/docview.wss?uid=swg21374788

[blom0344]

The datasource is defined in the model, so the dependency is through the model package and not by individual report. Even if you have 500 reports, if they all use the same package, then the relationship may not be much work finding out.

Up to a point you can query the content store for package - report dependency. But this type of metadata storage often uses complex recursive relationships  :o