Skip to main content link. Accesskey S
  • HCL Logo
  • HCL Connections On-Premise Wiki
  • THIS WIKI IS READ-ONLY.
  • HCL Forums and Blogs
  • Home
  • API Documentation
Search
Community Articles > Customization > Community report customization for Connections 4.0 Metrics
  • Share Show Menu▼

Recent articles by this author

Customizing reports based on the events captured in Metrics4.0

This artical will introduce the basic events list that Metrics track from Connections 4.0, and explain how to do the customized calculations based on these events during the reprot customization. The events that each Metrics standard report used will also be introduced in this article.

Community report customization for Connections 4.0 Metrics

This article introduces the community report customization steps for Connections Metrics 4.0, the main content break down into two parts: 'Create a customized report with Cognos Report Studio' and 'Add the customized report to the Community report list'.
Community articleCommunity report customization for Connections 4.0 Metrics
Added by ~Samuel Umjipytheroni | Edited by ~Samuel Umjipytheroni on March 25, 2015 | Version 6
  • Actions Show Menu▼
expanded Abstract
collapsed Abstract
This article introduces the community report customization steps for Connections Metrics 4.0, the main content break down into two parts: 'Create a customized report with Cognos Report Studio' and 'Add the customized report to the Community report list'.
Tags: Metrics, customization, report

This article provides two videos to show the detailed steps to complete the community report customization for Connections 4.0 Metrics, you can find them from the attachment list of this article.

Here are the main steps described in the video, for your reference.

Task 1:
Create a customized report with Cognos Report Studio

Steps:

 

  1. Open a browser and navigate to the Cognos dashboard using the following address: http://cognosserver.example.com:9083/cognos/servlet/dispatch/ext
  2. Log in to Cognos as the Cognos administrator.
  3. Create a new folder 'CustomReport' under folder 'IBMConnectionsMetrics' to save the new customized report that will be created.
  4. Click Launch > Report Studio, then select the package 'Metrics' to open Report Studio.
  5. Select to create a blank report.
  6. In the 'toolbox' panel, drag and drop 'Chart' to the report, then select chart type in the pop up window.
  7. Find the query name of this chart in the 'Properties' window, and open the query to add data items.
  8. Add data item 'App' to the query and edit the expression, for all available functions that can be used, refer to the 'Functions' panel on the expression window.
  9. Add data item 'Number of visits' to the query and edit the expression.
  10. Add data item 'Date' to the query and edit the expression.
  11. Add slicer to the query to only show the data for certain community.
  12. Go to reprot edit page, set data item 'Number of visits' to y-axis, 'Date' to x-axis and 'App' to series.
  13. Edit the char size for better look.
  14. Click 'Run' button on the toolbar box , input parameters to test the report.
  15. Go back to Report Studio, and add another chart with defferent type to the report by the same way.
  16. Save the report to the 'CustomReport' folder.


Notes:

 

 

  • Date item 'Date' (In video 00:03:10)

This data item is used to return the date points that selected from the Metrics UI date scope drop down. Just copy and use it will be ok.
The expression is:
lastPeriods(?upnum? , ancestor (#'[METRICS_TRX_CUBE].[DATE].[DATE].[DAY]->:[PC].[@MEMBER].['+ prompt('endDate' , 'integer') +']'#, #prompt('uplevel' , 'integer')# ) )

The 'lastPeriods(integer_expression , member )' is a Cognos dimensional function, this function returns the set of members from the same level that ends with "member".
The 'ancestor(member, integer)' is a Cognos dimensional function, this function returns the ancestor of "member" at "integer" number of levels above "member".
The '#' is Cognos macro expression label, which indicate the string surrounded by '#' is a macro expression and should be executed.
The 'prompt(name , type)' is a Cognos macro function to get the input from user.
The '?' also indicates the string surrounded by it is a input parameter from user. But this is not a macro function.

So this expression will receive the input parameter 'upnum', 'uplevel' and 'endDate', and calculate the date points need to show on the chart.

 

 

  • Slicer (In video 00:03:40)

This slicer is a filter that will return the community by community id. Slicers will be applied to all calculations in the query. Just copy and use it will be ok.
The expression is:
filter([METRICS_TRX_CUBE].[COMMUNITY].[COMMUNITY].[COMMUNITY NAME] , [METRICS_TRX_CUBE].[COMMUNITY].[COMMUNITY].[COMMUNITY NAME].[COMMUNITY NAME - Category Code]=?dcommunityid?)

The 'filter ( set_expression , Boolean_expression )' is a Cognos dimensional function that returns the set resulting from filtering a specified set based on the Boolean condition. Each member is included in the result if and only if the corresponding value of "Boolean_expression" is true.
The '[METRICS_TRX_CUBE].[COMMUNITY].[COMMUNITY].[COMMUNITY NAME]' is the member set of all communities.

So this expression nest all communities, and returns the community which's id equals parameter 'dcommunityid'.

 

 

  • About the dimensions definition used in the cube, refer to article PowerCube dimensions.

 


Task 2:
Add the customized report to the Community report list

Steps:

 

 

  1. Find the 'jobtemplate1' under folder Public Folders > IBMConnectionsMetrics > Metrics > static on Cognos dashboard.
  2. Add the customized report to the job list.
  3. Open Metrics page for a community to see the current page layout.
  4. Edit the 'reports-config.xml' to add the customized report to the UI.
  5. Refresh the community Metrics page, the new report link will appear.
  6. Click 'Update Metrics' to refresh the reports of this community.
  7. Wait for the report refresh complete, then fresh the page and click the new report link to see the report.


Notes:

 

  • Customized report label (In video 00:01:41)

This label is a string key that should be in below file:
Sample path: \IBM\WebSphere\AppServer\profiles\AppSrv01\installedApps\lwpvm220Cell01\Metrics.ear\lc.metrics.ui.jar\com\ibm\connections\metrics\ui\strings\ui.properties

In the video, just simply used the existing string as the report link label to do a demo, in the real case, you should add new string to this file and restart the application to take effect.


  • 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 14,619 KB Create-Customized-Report.wmv 9/28/12, 4:02 PM
application/octet-stream 6,742 KB Add-Community-Report.wmv 9/29/12, 4:46 AM
expanded Versions (1)
collapsed Versions (1)
Version Comparison     
VersionDateChanged by              Summary of changes
This version (6)Mar 25, 2015, 2:08:26 AM~Samuel Umjipytheroni  
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 ConnectedAbout
  • HCL Software
  • HCL Digital Solutions community
  • HCL Software support
  • BlogsDigital Solutions blog
  • Community LinkHCL Software forums and blogs
  • About HCL Software
  • Privacy
  • Accessibility