Cognos Session Variables

[TheCognosDave]

I haven't seen these clearly listed anywhere as a group, so now I found them, i'm posting them here for people to find..

#sq($account.defaultName)#	=>	lastname, firstname
#sq($account.personalInfo.email)#	=>	email
#sq($account.personalInfo.givenName)#	=>	firstname
#sq($account.personalInfo.surname)#	=>	lastname
#sq($account.personalInfo.userName)#	=>	userid

So for example, if you wanted some quick data security, if you had a table which included userid as a field and only wanted each user to see their own data.  You could just add a filter to the report

[table1].[userid]=#sq($account.personalInfo.userName)#

... and you'd be all set!

enjoy  ;)