COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 17 Aug 2011 01:10:16 PM

Title: Not getting user names with macro prompt
Post by: jd on 17 Aug 2011 01:10:16 PM
Hi, 
When I use below filter in my report I can't see my name in the user table:
upper([DN]) like upper('CN='+#sq($account.defaultName)#+'%')

when I use this filter I can see my name in the user table:
upper([DN]) =('CN=firstname.lastname,OU=CONTRACTOR,OU=PKI,OU=DOD,O=U.S. GOVERNMENT,C=US')

what is the wrong in first mentioned filter?

any idea?