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
------------------------------