Print Page - [SOLVED] List of which reports use which data source

Title: [SOLVED] List of which reports use which data source
Post by: kc9400 on 15 Aug 2013 07:33:22 AM

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.....

Title: Re: List of which reports use which data source
Post by: MFGF on 16 Aug 2013 05:44:35 AM

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.

Title: Re: List of which reports use which data source
Post by: jnovay@bspsoftware.com on 19 Aug 2013 02:58:09 PM

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

Title: Re: List of which reports use which data source
Post by: Grim on 20 Aug 2013 07:03:08 AM

Also SDK...

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

Title: Re: List of which reports use which data source
Post by: blom0344 on 20 Aug 2013 02:55:54 PM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: kc9400 on 15 Aug 2013 07:33:22 AM