How to display current users user groups in a report

[MellBI]

Hello,

I have a demand from a client to display the user groups a user belong to in a Report Studio Report.
The Cognos specific roles (Authors, Systems Administrator etc.) should not be displayed.

Anyone with ideas of how to solve this?

Regards
MellBI

[MellBI]

Hi,

I have an idea of running a query against Content Store and fetch all users with their user groups, filter to deselect the cognos roles, and then include this query in the Framework Manager project. Then I create a relation where i pick up the current user name and join it with the data from Content Store.
When I run the report I recognize the user and just include the field for user group.

Anyone who think it could work?

/MellBI

[MFGF]

Hi,

You could try adding a calculation utilising the #CSVIdentityNameList()# macro function as a starting point.  This will return the user's account name, group and role names in a quoted, comma-separated list.  You could then manipulate this to remove the account name and Cognos specific roles.

MF.

[cognos_geek]

Here's what I used just to get everything displayed on the report:

Create a query and one query item defined with the macro below:

#sq(join('||',array(csvidentitynamelist())))#

Maybe you could use the substitute function multiple times to get rid of any Cognos roles.