If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Implementing Security using Parameter Maps

Started by Naven, 10 Dec 2008 05:39:46 AM

Previous topic - Next topic

Naven

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