Print Page - Need to check user ID dynamically

Title: Need to check user ID dynamically
Post by: Sundaramoorthy on 01 Jul 2016 11:27:23 PM

We are having a requirement like need to validate the user based on his user id in report..but we are not having that user info table in current package..so,in order to achieve it, we are referring the customized SQL in report..

For validating the user id during report execution, we are supposed to have dynamic filters like CAMID for getting that user id..But as per the analysis, CAMID is returning only the user's mail address...

please suggest like is there any way to get that dynamic user id

Title: Re: Need to check user ID dynamically
Post by: hespora on 04 Jul 2016 02:38:10 AM

Code Select

#sq($account.personalInfo.userName)#

Title: Re: Need to check user ID dynamically
Post by: Sundaramoorthy on 05 Jul 2016 09:26:58 AM

Thank you, Hespora..i also explored with the same & got the expected output.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Sundaramoorthy on 01 Jul 2016 11:27:23 PM