COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: elan_paul on 28 Dec 2010 10:31:23 PM

Title: Rendering of reports for multiple groups in Cognos
Post by: elan_paul on 28 Dec 2010 10:31:23 PM
Hi,

We have a requirement where we need to render reports  dynamically based on the groups to which the user belong.We have multiple groups which have been created in LDAP.
The name of the group for a particular user is created as an attribute in LDAP.We have taken that attribute as a session parameter and are able to render reports using Conditional block via string variable in Cognos for a particular user.This is working only if one user is belonging to one group only.

Now there is a scenario in which one user can belong to two or mutilpe groups  eg:- Group A,Group B etc which are there in LDAP. We are able to retreive all the groups for one user using macro function csvidentitynamedlist in Framework manager.

It is giving all group names like Group A, Group B for one user. But we are facing issues on how to use it for rendering of reports dynamically. So in that case we need to show the reports for both Group A , Group B for that user.

If anybody have worked on a similar requirement on how to render reports based on multiple groups for a single user, it would be very helpful if you can give some ideas on it.

Regards,
Elan
Title: Re: Rendering of reports for multiple groups in Cognos
Post by: screwdrive on 17 Nov 2021 10:33:01 AM
Hi- Were you ever able to achieve this? Please share. Thanks!
Title: Re: Rendering of reports for multiple groups in Cognos
Post by: CognosPaul on 17 Nov 2021 02:27:35 PM
Instead of using a conditional block, use a series of blocks with render variables. The render variables should be something like [Query].[groups] contains 'Security group 1'.