COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: raj_aries on 06 Aug 2013 11:18:10 PM

Title: Q:How to display the list of Cog Groups for a specific user from report Studio
Post by: raj_aries on 06 Aug 2013 11:18:10 PM
Hi All,

As a report author, is there a way to display the list of Cognos Groups for a specific user from Report Studio. CSVIdentityNameList will give the details of the user who is running the report. However, I should be able to pass the user as a parameter so that it displays the corresponding groups for that user.

Since I am not an administrator, I don't have enough privileges to impersonate myself as user of another group.

Any information in this regard is really helpful and appreciated.



Thanks & Regards
Raj.


Title: Re: Q:How to display the list of Cog Groups for a specific user from report Studio
Post by: raj_aries on 07 Aug 2013 01:54:15 PM
Hi All,

Could someone help me out with this -

I need to retrieve list of  cognos groups for a user (not the current user who is logged in) in report studio.

Is there a way where I could specify 'specific user' as a parameter for any of the macro functions.


Regards
Raj
Title: Re: Q:How to display the list of Cog Groups for a specific user from report Studio
Post by: annadanna on 07 Aug 2013 03:06:19 PM
There is a way to do this although you may not have access. There are administration tables in cognos which you can use to create this report. For me its in the cognos content store package and then the User Group Role Security drop down under Roles.
Title: Re: Q:How to display the list of Cog Groups for a specific user from report Studio
Post by: raj_aries on 08 Aug 2013 12:28:45 AM
Hi Annadanna,

Yes, I don't have access to admin tables and customer is adamant on giving/changing my user group. My intention is to implement data security using CSVIdentityNameList in the report and I wanted to test it for few users before deploying this to prod.

Something like this [Region_Id]=#CSVIdentityNameList()# and [Group_Id]=#CSVIdentityNameList()#..etc so that it filters the corresponding [Region_Id] and [Group_Id].

Thanks
Raj