Report Level Security

[aitzazali]

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.

[MFGF]

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.