Hi all,
We have a scenario in a project where we need to restrict specific users to specific prompt values in a report.
For e.g.
There is a prompt for Location containing values as;
location 1
location 2
Now I want to restrict User 1 to location1 data only and User 2 to location2 data only. How can this be done?
Any insight or reference is highly appreciated.
The easiest solution to this would be to add "Data Security" to your model in Framework Manager - you can define filters for query subjects/query items based on selected users/groups/roles in your security namespace. Once you republish your package, these filters then automatically apply whenever the relevant query subjects/query items are referenced.
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_fm.10.1.0.doc%2Fug_fm_id16015AddDataSecurity.html
Regards,
MF.