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

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

Thanks Andrejs for suggestion

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

Original Message:
Sent: Wed February 19, 2020 02:51 AM
From: Andrejs kuliks
Subject: How to extract user usage from cognos

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

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

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

Original Message:
Sent: Wed February 19, 2020 07:27 AM
From: William Sai-Palm
Subject: How to extract user usage from cognos

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

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

Original Message:
Sent: Wed February 19, 2020 07:27 AM
From: William Sai-Palm
Subject: How to extract user usage from cognos

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

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

Original Message:
Sent: Thu February 20, 2020 01:39 AM
From: Wai Wai
Subject: How to extract user usage from cognos

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


Original Message:
Sent: Wed February 19, 2020 07:27 AM
From: William Sai-Palm
Subject: How to extract user usage from cognos

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

Thanks Luke for your detail information and reference link :)

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

Original Message:
Sent: Thu February 20, 2020 06:39 PM
From: Luke Peterson
Subject: How to extract user usage from cognos

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


Original Message:
Sent: Thu February 20, 2020 01:39 AM
From: Wai Wai
Subject: How to extract user usage from cognos

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


Original Message:
Sent: Wed February 19, 2020 07:27 AM
From: William Sai-Palm
Subject: How to extract user usage from cognos

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