ShowTable of Contents
In IBM Connections 4.0 Metrics, the community owner will need submit the update metrics request and wait for the reports to be generated. This may take a long time depend on the Cognos server hardware configuration.
Customer can apply following one or more options to reduce the wait time for the community metrics:
Option 1: Reduce the time ranges that available for community metrics
Out-of-box there are 5 default time ranges available for community metrics. There are:
Last 7 days
Last 4 weeks
Last 12 months
Customer can remove the time ranges that they feel are not or less important to their usage to reduce the time that needed to generate community report. Remove one time range will reduce about 20% of the total time to generate reports for one community.
Remove the Last quarter time range by set the communitiesMetricsDateRange.last7days.enabled value to false, using following method:
Please refer Modifying configuration properties
to modify the metrics configuration to apply the changes.
Also refer Metrics configuration properties for properties need to be modified (communitiesMetricsDateRanges).
Options 2: Reduce the people group by filter that available for Metrics
Out-of-box there are 3 default people group by filter available for both global and community metrics:
Customer can remove the filter that they feel are not or less important to their usage to reduce the time that needed to generate community report. Remove one filter will reduce about 10-15% of the total time to generate reports for one community.
Please refer Mapping user profile attributes to report dimensions to check out/check in the metrics-config.xml file.
Modify the metrics-config.xml file with update the userAttributesMappings section by put xml comment code around the mapping attributes that need to be removed. For example, remove the Department and Role filters by add the highlighted code for mapping attribute2 and attribute3:
<!-- Users need to add PII strings for these attributes -->
<mapping metricsName="attribute1" profilesName="com.ibm.snx_profiles.base.countryCode" />
<!--<mapping metricsName="attribute2" profilesName="com.ibm.snx_profiles.base.orgId" />-->
<!--<mapping metricsName="attribute3" profilesName="com.ibm.snx_profiles.base.title" />-->
Note: remove this filter mapping will also impact global metrics. The global metrics report users will not be able to view those removed people group by filters any more.
The next steps are to remove attribute2 and attribute3 from static jobtemplates in Cognos BI:
Login the Cognos BI console in http://[Cognos_Server_hostname]:[port]/cognos/servlet/dispatch/ext? with cognos administrator
Goto Public Folders > IBMConnectionsMetrics > Metrics > static
Edit properties for jobtemplate4, in Job tab, remove people_attribute2 and people_attribute3 in jobtemplate4.
Edit properties for jobtemplate5, in Job tab, remove participation_attribute2 and participation_attribute3 in jobtemplate5.
Save the changes
Note: If you want add the filter back, you can add the jobs back to the jobtemplate4 an 5. people_attributes jobs are Public Folders > IBMConnectionsMetrics > Metrics > community > peopleTheme; participation_attributes jobs are in Public Folders > IBMConnectionsMetrics > Metrics > community > participationTheme.
developerWorks IBM Connections product page:
IBM Connections 4.0 Reviewers Guide:
IBM Connections Forum:
About the authors
Nan Shi is an Advisory Software Engineer working for IBM since 2006. His current role is the Architect for Metrics feature in IBM Connections, before which he worked on Moderation in Connections, Lotus Quickr, Master Data Management, Wepsphere Customer Center. He can be contact at firstname.lastname@example.org