Cognos Analytics

 View Only
  • 1.  Cognos session parameters

    Posted Thu October 03, 2019 09:55 AM

    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


  • 2.  RE: Cognos session parameters

    Posted Thu October 03, 2019 10:13 AM
    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
    ------------------------------



  • 3.  RE: Cognos session parameters

    Posted Thu October 03, 2019 02:16 PM

    Thanks you @HENK CAZEMIER

    I will try it and let you know...​​