Hi Richard,
Have you looked at
CAMIDListForType ( identity type )
Returns an array of the user's Cognos® Access Manager IDs (CAMIDs) based on the identity type (account, group, or role). CAMIDListForType can be used with the macro functions csv or join.
Example: [qs].[userRole] in ( # csv ( CAMIDListForType ( 'role' ) ) # )
Result: [qs].[userRole] in ( 'CAMID ( "::System Administrators" ) ' , 'CAMID ( ":Authors" )' )
// Henk
------------------------------
HENK CAZEMIER
------------------------------
Original Message:
Sent: Thu October 03, 2019 09:54 AM
From: Richard Mabjish
Subject: Cognos session parameters
Hello all,
I'm looking for a session parameter I could use at run time to return a list of Cognos Groups and Roles the user is member of?
I'm not interested in other groups that exist in the authentication source (ex: ActiveDirectory), only interested in Cognos Groups/Roles membership.
I'm currently using CSVIdentityNameList( )
and array( CAMIDList( ))
but both return active directory groups in addition to Cognos Groups, which results in too many values returned.
Any ideas greatly appreciated.
#CognosAnalyticswithWatson