COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: matteo on 23 Oct 2013 11:54:11 PM

Title: how to get the User ID?
Post by: matteo on 23 Oct 2013 11:54:11 PM
Good morning all,

In my report I have several data related to the User ID.
How can I get the User ID?
I mean: is there any way to get the ID of the person who logged in Cognos?

Many thanks.

Ciao

Matty
Title: Re: how to get the User ID?
Post by: MFGF on 24 Oct 2013 03:14:11 AM
Hi,

You can reference the user name stored in a session parameter (account.personalInfo.userName) using a macro in a query calculation - eg

#sq($account.personalInfo.userName)#

Cheers!

MF.
Title: Re: how to get the User ID?
Post by: matteo on 24 Oct 2013 09:05:49 AM
Thanks MF!

That's what I needed!

I really appreciate.

Have a good day.

Ciao

Matty