Print Page - Filter on a Value Prompt

Title: Filter on a Value Prompt
Post by: akhattri on 26 Jun 2009 02:36:42 PM

Hi All,
I have report requirement where the user wants to view only certain values on the prompt to be displayed. i.e. If I have values A,B,C,D,E,F for a column in a table, the user wants to see only values A,B,C on the Prompt to be displayed and then make his selection out of those and the report should filter based on those. How is it achievable?

Thanks!

Title: Re: Filter on a Value Prompt
Post by: nfldbunker on 27 Jun 2009 06:40:46 AM

HI

I have a similar report request where i have maye 1000 codes and associated descriptions in a table but only want the users to be able to select in the prompt maybe 100 of those codes and desc.

let me know how you make out ..my post if the first at the top of the report section

Title: Re: Filter on a Value Prompt
Post by: Gopinath on 29 Jun 2009 12:55:35 AM

Add a filter in your prompt query(Query associated to your value prompt) to restrict the value displayed in your prompt

Title: Re: Filter on a Value Prompt
Post by: kalyan_y on 29 Jun 2009 06:19:00 AM

Create user groups and apply Object level security(Security Filters) at FM level on the query subject for which you want to display the data based on the user logged in.

Title: Re: Filter on a Value Prompt
Post by: akhattri on 29 Jun 2009 09:08:44 AM

Thanks Gopinath! Yours is the solution I was looking for.

Kalyan, thanks for your input also, but we did not want to implement security.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: akhattri on 26 Jun 2009 02:36:42 PM