COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: bluecarbon on 14 Sep 2012 01:48:31 PM

Title: Idetify the datasource used in each namespace
Post by: bluecarbon on 14 Sep 2012 01:48:31 PM
Hi,
I have a project having many namespaces and data sources. Please let me know how can i identify which datasource is used for which namespace or query subject.
It would be great if you elobrate the steps to identify the datasources used.
Title: Re: Idetify the datasource used in each namespace
Post by: RKMI on 14 Sep 2012 06:25:01 PM
Hi,

If you want to figure out your datasource just right click on the query subject -> edit definition -> query information on the bottom right there is Test Sample which will retrive cognos genrated SQL which should point you to your data source.

If you are trying to identify which are you database layer object they will be denoted with a different icon with a database symbol, other with it will be model query subjects which point to your database query subject. I hope this helps...  :)

Thanks,
RK
Title: Re: Idetify the datasource used in each namespace
Post by: bluecarbon on 27 Sep 2012 12:48:03 PM
Hi,
Thanks for your helpl. I have identified the database name and credentials of a Data source from Cognos Administration menu in Cognos Connection.