COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: TheCognosDave on 24 Oct 2013 09:46:39 AM

Title: Cognos Session Variables
Post by: TheCognosDave on 24 Oct 2013 09:46:39 AM
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  ;)