COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: gatorfe on 11 Jan 2011 09:16:03 AM

Title: Location of fields n Query Studio
Post by: gatorfe on 11 Jan 2011 09:16:03 AM
Is there way to see where fields in Query Studio come from?  Like in Report Studio if I click on it,  Iget the location of the field.  Is there something like that in QS?  Thanks in advance for you help!
Title: Re: Location of fields n Query Studio
Post by: MFGF on 11 Jan 2011 10:15:27 AM
Hi,

In the blue Menu area, select the 'Manage File' link, then from the menu on the left choose 'Report Definition'.  This will list the fields included in the query and show their unique names in the package.

You can also right-click on a column and use the 'Lineage' option to see how the value has been sourced and derived, right back as far as the underlying data source.

Regards,

MF.