COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: dmhackett8 on 13 Sep 2016 02:18:58 PM

Title: Find How Many Times a Field is Used in "X" Reports
Post by: dmhackett8 on 13 Sep 2016 02:18:58 PM
Hello,

I'm wondering if there's a way to search all created reports for use of a specific field. For example, someone asks me if changing "x" field will affect any reports I've made. I've made MANY reports and can't remember all of them that reference a specific field.

Any easy way to check this?

Thanks,

Dave
Title: Re: Find How Many Times a Field is Used in "X" Reports
Post by: bdbits on 13 Sep 2016 05:47:09 PM
If you have access to Framework Manager and the model for your package, you can do that quite easily.
Title: Re: Find How Many Times a Field is Used in "X" Reports
Post by: raj_aries81 on 13 Sep 2016 06:28:48 PM
Open Framework Manager and under Tools-->Find Report Dependencies gives you the list of reports impacted. If you are building a new Framework Model, I would recommend to use Durable Models feature.

http://www.ibm.com/developerworks/data/library/cognos/page60.html


Thanks & Regards
Raj