COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Cognos8 on 28 Oct 2014 03:58:18 PM

Title: Identify Columns used in reports
Post by: Cognos8 on 28 Oct 2014 03:58:18 PM
I have two columns which i have used across multiple reports.I need to identify which are all the reports using these two columns. without SDK how can i find this ?
Title: Re: Identify Columns used in reports
Post by: cognostechie on 28 Oct 2014 06:30:49 PM
You can get this from Framework Manager (assuming your reports are using a Framework package). Locate those fields in the Physical/Database Layer, click on them, from the Tools Menu select 'Find Report Dependencies'. This takes some time and generates
an xml file which will have name and path of reports using the fields.