-
Book Overview & Buying
-
Table Of Contents
IBM Cognos 8 Report Studio Cookbook
By :
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'.
Open a new list report with GO Data Warehouse (Query) as the package.
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.
Here we are using a macro function called CSVIdentityNameList. This function returns a list of...
Change the font size
Change margin width
Change background colour