If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Radio button group prompt, filter by user

Started by jsilver, 28 Oct 2010 10:55:12 AM

Previous topic - Next topic

jsilver

I would like to filter a "radio button group" prompt depending on the user logged in.  For example, assume a radio button prompt exists with three options (state, county, town).  If UserA is logged in, I want all three options to display (i.e., state, county, town).  If UserB is logged in, I want just the first two options to display (i.e., state, county).  Additionally, I would like to extend this functionality to "anonymous" users.  Using the same radio button example, if an anonymous user is running the report, I want just the first two options to display (i.e., state, county).

Thanks in advance for your help.

bloggerman

One way is you could use data security feature, which would implement a filter on a query subject based on a condition, logged in user. You can then use the relevant field from the query subject in the prompt.

jsilver

Thanks for the quick response.  Can this be implemented at the report level or does this have to be at the FM model level?