COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Query Studio => Topic started by: sumesh2429 on 21 Jul 2015 05:28:41 AM

Title: Use and Display value filters in QS
Post by: sumesh2429 on 21 Jul 2015 05:28:41 AM
Hi ,

In Query studio ,  if user pulls column like "Operating Unit Name" for  filter  , i want to pass the "Operating Unit ID" . Is there as way to achieve this ? The same functionality we have in Report Studio where we pass USE VALUE as Operating Unit ID from Prompt while Operating unit name as DISPLAY VALUE
Title: Re: Use and Display value filters in QS
Post by: Lynn on 21 Jul 2015 06:01:28 AM
The modeler of your package has Prompt Info properties for each data item where the display, filter, and use references can be specified. Otherwise you'd be best served by moving to Workspace Advanced since Query Studio is going bye-bye.
Title: Re: Use and Display value filters in QS
Post by: sumesh2429 on 21 Jul 2015 07:09:21 AM
Thanks Lynn.. Your suggestion helps :)