Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: anjan on 05 Dec 2012 06:33:36 AM

Title: Get user role, group
Post by: anjan on 05 Dec 2012 06:33:36 AM
Hello All,

Is there a way to get user role and group in report studio, the role and group are create in cognos admin.

Thanks,
Title: Re: Get user role, group
Post by: Bark on 05 Dec 2012 07:56:31 AM
The macro function #CSVIdentityNameList# will give you that information:

http://pic.dhe.ibm.com/infocenter/cbi/v10r1m1/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_fm.10.1.1.doc%2Fc_usingthecsvidentitynamelistmacrofunction.html

Regards,

Bark
Title: Re: Get user role, group
Post by: anjan on 05 Dec 2012 08:26:04 AM
I have used it but it gaves lot of other stuff and was not able to find the role name in that list , which user belong to.

The role is create in cognos
Title: Re: Get user role, group
Post by: Bark on 05 Dec 2012 09:41:46 AM
It is supposed to return all groups and roles regardless where they were created (just checked in my portal and it performs as expected). Could you provide a specific example?

Thanks and regards,

Bark
Title: Re: Get user role, group
Post by: jeffowentn on 05 Dec 2012 01:25:27 PM
Bark,

Where does this macro get used to generate the info?  Is this a Report Studio thing or something else?  I'm primarily a Planning user, but I'm trying to get up to speed on the BI Admin side to support our Planning administration.

Thank you,
Jeff
Title: Re: Get user role, group
Post by: Bark on 06 Dec 2012 03:20:16 AM
It can be used in Report Studio or directly in Framework Manager and it should return the groups and roles (among other information) of the user running the report (running the dataItem).

Regards,

Bark
Text only | Text with Images