A report shows the employee names by region and country. We need to implement data security in this report such that a user can see the records only for the country he belongs to. There are already User Groups defined on the Cognos server (in the directory) and users are made members of appropriate groups.
For this sample, I have added my user account to a user group called 'Spain'.
Drag the appropriate columns (Region, Country, and Employee name) on to the report from Employee by Region query subject.
Go to Query Explorer and drag a new detail filter.
Define the filter as:
[Country] in (#CSVIdentityNameList(',')#)
Run the report to test it. You will notice that a user can see only the rows of the country/countries of which he is a member.