Q:How to display the list of Cog Groups for a specific user from report Studio

[raj_aries]

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.

[raj_aries]

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

[annadanna]

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.

[raj_aries]

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