Adding data-level security using the CSVIdentityMap macro
Let's say that a report shows the employee names by region and country. We need to implement data security in this report so that a user can see the records only for the country they belong to. There are User Groups already defined on the Cognos server (in the directory) and users are made members of appropriate groups. For this recipe, I have added my user account to a user group called Spain.
Getting ready
Open a new list report with GO Data Warehouse (query) as the package.
How to do it...
In this recipe, we will start by creating a new list report using the following steps:
- Drag the appropriate columns (Country, City, and Employee name) onto the report from the Employee by Region query subject: ...
Get IBM Cognos 10 Report Studio Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
