COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Naven on 10 Dec 2008 05:39:46 AM

Title: Implementing Security using Parameter Maps
Post by: Naven on 10 Dec 2008 05:39:46 AM
Hi,

We have created a parameter map which uses session parameters(account.defaultName) to implement data security in reports.

In detail, we have entered User Id's in two columns.The User Id's in Key column will be able to see data of User Id's in value column(i.e 198613 will be able to see 231023 Id's data and so on).

  Key          Value
198613      231023
150184      231026

There is no problem if I pass a single parameter i.e user ID-198613 to access data of a single User Id-231023.But, I have a requirement where I need to pass a single parameter i.e User ID(Key) to access more than one User Id's data(Value).
198613 should be able to access data of both 231023 and 231026.
It is not possible to enter 198613 in Key column more than one time because it has to be unique.
Is there any workaround?

Thanks,
Naveen