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