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