Author Topic: Retrieve the user's User-Group / User-Role as a Session Parameter  (Read 103 times)

Offline bi4business

  • Community Leader
  • *****
  • Join Date: Dec 2009
  • Posts: 80
  • Forum Citizenship: +0/-1
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,


Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,270
  • Forum Citizenship: +662/-10
  • Cognos Software Muppet
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.
Meep!

Offline bi4business

  • Community Leader
  • *****
  • Join Date: Dec 2009
  • Posts: 80
  • Forum Citizenship: +0/-1
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,