COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: bi4business on 04 May 2021 01:33:37 AM

Title: Retrieve the user's User-Group / User-Role as a Session Parameter
Post by: bi4business on 04 May 2021 01:33:37 AM
Hi All,

Is there a way (session Parameter?) to retrieve the current user UserGroup / UserRole within a Report of a user ?

I would like to grap the usergroup(s) / Userrole(s) the current user is part of but can't find how to grap that.
Found some post with SQL statements at the Content-Store, but I don't like using the Content-Store for that.

Has anybody done this before within a Report ?

Kind Regards,

Title: Re: Retrieve the user's User-Group / User-Role as a Session Parameter
Post by: MFGF on 04 May 2021 07:08:52 AM
Quote from: bi4business on 04 May 2021 01:33:37 AM
Hi All,

Is there a way (session Parameter?) to retrieve the current user UserGroup / UserRole within a Report of a user ?

I would like to grap the usergroup(s) / Userrole(s) the current user is part of but can't find how to grap that.
Found some post with SQL statements at the Content-Store, but I don't like using the Content-Store for that.

Has anybody done this before within a Report ?

Kind Regards,

Hi,

Often a user will belong to multiple groups and roles. The CSVIdentityNameList() macro function returns all the groups and roles a user belongs to (along with the user's identity).

Cheers!

MF.
Title: Re: Retrieve the user's User-Group / User-Role as a Session Parameter
Post by: bi4business on 04 May 2021 11:16:41 AM
Hi MF,

Thanks a lot, I didn't know about this macro function.
You are never to old to learn  ;D  ;D

Exactly what I needed, thanks again.

Kind Regards,