Author Topic: Rendering of reports for multiple groups in Cognos  (Read 1281 times)

Offline elan_paul

  • Associate
  • **
  • Join Date: Dec 2010
  • Posts: 2
  • Forum Citizenship: +0/-0
Rendering of reports for multiple groups in Cognos
« 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

Offline screwdrive

  • Full Member
  • ***
  • Join Date: Dec 2008
  • Posts: 13
  • Forum Citizenship: +0/-0
  • It feels good to be lost in the right direction!
Re: Rendering of reports for multiple groups in Cognos
« Reply #1 on: 17 Nov 2021 10:33:01 am »
Hi- Were you ever able to achieve this? Please share. Thanks!

Offline CognosPaul

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Jan 2009
  • Posts: 1,901
  • Forum Citizenship: +268/-1
    • Paul's Cognos Blog
Re: Rendering of reports for multiple groups in Cognos
« Reply #2 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'.