Skip to main content link. Accesskey S
  • Help
  • IBM Logo
  • IBM Connections wiki
  • All Wikis
  • All Forums
  • THIS WIKI IS READ-ONLY. Learn more...
  • Home
  • Product Documentation
  • Community Articles
  • Learning Center
  • IBM Redbooks
  • API Documentation
Search
Community Articles > Customization > Connections 4.0 Metrics customization: create new Cognos metrics report
  • Share Show Menu▼
  • Subscribe Show Menu▼

About the Original Author

Click to view profileIBM contributorNan BJ Shi
Contribution Summary:
  • Articles authored: 2
  • Articles edited: 0
  • Comments Posted: 0

Recent articles by this author

Connections 4.0 Metrics customization: create new Cognos metrics report

This article introduces demo videos show how to create a new Cognos metrics report for Connections Metrics 4.0.

Reduce the community metrics request waiting time in IBM Connections 4.0 Metrics

Introduction of few tips to reduce the community metrics request waiting time in IBM Connections 4.0 Metrics
Community articleConnections 4.0 Metrics customization: create new Cognos metrics report
Added by IBM contributorNan BJ Shi | Edited by IBM contributorNan BJ Shi on March 7, 2013 | Version 13
  • Actions Show Menu▼
Rate this article 1 starsRate this article 2 starsRate this article 3 starsRate this article 4 starsRate this article 5 stars
expanded Abstract
collapsed Abstract
This article introduces demo videos show how to create a new Cognos metrics report for Connections Metrics 4.0.
Tags: metrics, cognos, report, customization

This article provides two demo videos to show the detailed steps to create new Cognos metrics report for Connections 4.0 Metrics, you can find them from the attachment list of this article.

 

1. New Cognos metrics report to show number of visit for community metrics.

Video: number of visit for community metrics.mp4

 

Expressions used in this video:

 

Date item 'Date' (in video 00:06:08):

lastPeriods(?upnum? , ancestor (#'[METRICS_TRX_CUBE].[DATE].[DATE].[DAY]->:[PC].[@MEMBER].['+ prompt('endDate' , 'integer') +']'#, #prompt('uplevel' , 'integer')# ) )

 

Slicer (in video 00:07:12):

filter([METRICS_TRX_CUBE].[COMMUNITY].[COMMUNITY].[COMMUNITY NAME] , [METRICS_TRX_CUBE].[COMMUNITY].[COMMUNITY].[COMMUNITY NAME].[COMMUNITY NAME - Category Code]=?dcommunityid?)

 

2. New Cognos metrics report to show inactive communities for global metrics.

Video: inactive communities.mp4

 

Expressions used in this video:

 

Date item 'Date Range' (in video 00:00:57):

lastPeriods (6, closingPeriod ([METRICS_TRX_CUBE].[DATE].[DATE].[MONTH]))

 

Date item "Total inactive communities" (in video 00:01:39, 00:05:35):

total( 1 within set filter ([METRICS_TRX_CUBE].[COMMUNITY].[COMMUNITY].[COMMUNITY NAME], total ((tuple([CREATE])+tuple([UPDATE])) within set [Date Range]) = 0))

total( 1 within set filter ([METRICS_TRX_CUBE].[COMMUNITY].[COMMUNITY].[COMMUNITY NAME], total ((tuple([CREATE])+tuple([UPDATE])+tuple([VISIT])) within set [Date Range]) = 0))

 

Date item "Total active communities" (in video 00:03:05, 00:06:08):

total( 1 within set filter ([METRICS_TRX_CUBE].[COMMUNITY].[COMMUNITY].[COMMUNITY NAME], total ((tuple([CREATE])+tuple([UPDATE])) within set [Date Range]) > 0))

total( 1 within set filter ([METRICS_TRX_CUBE].[COMMUNITY].[COMMUNITY].[COMMUNITY NAME], total ((tuple([CREATE])+tuple([UPDATE])+tuple([VISIT])) within set [Date Range]) > 0))

 

Date item "Inactive communities" (in video 00:07:24):

filter ([METRICS_TRX_CUBE].[COMMUNITY].[COMMUNITY].[COMMUNITY NAME], total ((tuple([CREATE], [EVENT_COUNT])+tuple([UPDATE], [EVENT_COUNT])+tuple([VISIT], [EVENT_COUNT])) within set [Date Range]) = 0)

 

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 nanshi@cn.ibm.com


  • Actions Show Menu▼


expanded Attachments (2)
collapsed Attachments (2)
Edit the article to add or modify attachments.
File TypeSizeFile NameCreated OnDelete file
application/octet-stream 13,739 KB number of visit for community metrics.mp4 3/6/13, 4:21 AM
application/octet-stream 12,901 KB inactive communities.mp4 1/25/13, 3:00 AM
expanded Versions (13)
collapsed Versions (13)
Version Comparison     
VersionDateChanged by              Summary of changes
This version (13)Mar 7, 2013, 6:49:12 AMNan BJ Shi  IBM contributor
12Mar 7, 2013, 6:46:57 AMNan BJ Shi  IBM contributor
11Mar 7, 2013, 6:44:40 AMNan BJ Shi  IBM contributorMinor change
10Mar 7, 2013, 6:43:29 AMNan BJ Shi  IBM contributorMinor change
9Mar 7, 2013, 6:41:08 AMNan BJ Shi  IBM contributor
8Mar 7, 2013, 5:03:19 AMNan BJ Shi  IBM contributor
7Mar 7, 2013, 4:45:54 AMNan BJ Shi  IBM contributor
6Mar 7, 2013, 4:30:48 AMNan BJ Shi  IBM contributor
5Mar 7, 2013, 4:15:12 AMNan BJ Shi  IBM contributor
4Mar 7, 2013, 3:12:15 AMNan BJ Shi  IBM contributor
3Mar 7, 2013, 3:11:42 AMNan BJ Shi  IBM contributorMinor change
2Mar 7, 2013, 2:59:29 AMNan BJ Shi  IBM contributor
1Mar 7, 2013, 2:03:23 AMNan BJ Shi  IBM contributor
expanded Comments (0)
collapsed Comments (0)
Copy and paste this wiki markup to link to this article from another article in this wiki.
Go ElsewhereStay ConnectedHelpAbout
  • IBM Collaboration Solutions wikis
  • IBM developerWorks
  • IBM Software support
  • Twitter LinkIBMSocialBizUX on Twitter
  • FacebookIBMSocialBizUX on Facebook
  • ForumsLotus product forums
  • BlogsIBM Social Business UX blog
  • Community LinkThe Social Lounge
  • Wiki Help
  • Forgot user name/password
  • About the wiki
  • About IBM
  • Privacy
  • Accessibility
  • IBM Terms of use
  • Wiki terms of use