Cognos Analytics

 View Only
  • 1.  How to extract user usage from cognos

    Posted Tue February 18, 2020 09:26 PM
    Hi

    Can anyone lighten me how to extract the user usage from Cognos 10.2? And also would like to know how can I check the active users and inactive users together with their specific roles and group name. Also would like to extract those info from Cognos.

    Thanks and Best Regards,
    Wai Wai





    ------------------------------
    Wai Wai Data Engineer
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: How to extract user usage from cognos

    Posted Wed February 19, 2020 02:52 AM
    Hi,
    There's no ready report for this unfortunately.
    I'm using following workaround:
    1. Get standard user report and put it in Excel so you have a list of users in column A. Use =trim() if needed.
    2. I'm taking a log file for last 3 months based on following user activity - data entry, - import from flat file, - import from Excel. Conditions may vary depending on your environment.
    3. Put this log into second spreadsheet, use trim again to make sure users ID are the same as in A.
    4. Use vlookup on the first sheet in B (=IFERROR(VLOOKUP(A169;Sheet0!A:B;2;FALSE);"NO ACTIVITIES IN COGNOS FOR LAST 3 MONTHS"))
    You're done.
    Regards,
    Andrejs

    ------------------------------
    Andrejs kuliks
    ------------------------------



  • 3.  RE: How to extract user usage from cognos

    Posted Thu February 20, 2020 01:34 AM
    Thanks Andrejs for suggestion

    ------------------------------
    Wai Wai Data Engineer
    ------------------------------



  • 4.  RE: How to extract user usage from cognos

    Posted Wed February 19, 2020 09:30 AM
    First Cognos Analytics comes with a number of audit reports. Have you installed the audit module and tried out any of the reports? There are other utilities out there as well such as the IBMCognosAnalytics_UsersCapabilities developed by the SDK team. You should look it up and try. This will give you the active/ inactive group membership information. Finally, get a free copy of Motio and play with it. 
    Thanks
    >>BS


    ------------------------------
    William Sai-Palm
    ------------------------------



  • 5.  RE: How to extract user usage from cognos

    Posted Wed February 19, 2020 12:11 PM
    I checked the IBM support site for the file. The only ones listed are for 10x.Is there a similar file for 11x. It looks like a useful tool that should be incorporated into the admin reports

    ------------------------------
    Kwadwo Obeng
    ------------------------------



  • 6.  RE: How to extract user usage from cognos

    Posted Thu February 20, 2020 01:39 AM
    Hi William,

    Thanks for suggestion. Is there any link to refer how to install and use audit module?

    Best Regards,
    Wai Wai

    ------------------------------
    Wai Wai Data Engineer
    ------------------------------



  • 7.  RE: How to extract user usage from cognos

    Posted Thu February 20, 2020 06:40 PM
    Hello,

    IBM Cognos Analytics provides the ability to record when users have logged in along with when they have run reports. Product documentation includes information on how to set up auditing. Here is an example: https://www.ibm.com/support/pages/how-configure-audit-reporting-cognos-analytics
    The Cognos Analytics installation also includes sample reports and models that you can use to get a head start on audit reporting. https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ig_smples.doc/t_settingupauditreportlogging.html
    As described, this audits user activity, not what permissions or object access users have. In order to audit user access and capabilities, Cognos Analytics includes basic reporting straight from the manage menu: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/t_ca_licenses.html. If you need more detailed information, IBM provides an Audit Extension. Find out more about the audit extension at the IBM developer site: https://developer.ibm.com/technologies/analytics/tutorials/ibm-cognos-11-audit-extension/

    Based on the original question, if you want to audit which users belong to which security groups and roles then the Account Audit capability from the Audit Extension should suit this purpose. Of course the IBM SDK team can deliver a solution, or you could investigate third party applications to deliver something similar. For Cognos Analytics use the link above. The original question indicates version 10.2: https://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html

    ------------------------------
    Luke Peterson
    Business Analytics Advocate
    IBM
    ------------------------------



  • 8.  RE: How to extract user usage from cognos

    Posted Wed March 11, 2020 11:38 PM
    Thanks Luke for your detail information and reference link :)

    ------------------------------
    Wai Wai Data Engineer
    ------------------------------