How to collect data from IBM Cognos

This article will show you how to create a Metric or Report using a Cognos report as a data source. It assumes that you have already established connectivity to your Cognos server.

1. Access New > Report

  1. Name the Report: Define a unique descriptive name of your element
  2. Reported: choose the measurement interval from the drop-down list
  3. Category: define a category this element belongs to
  4. To move on to defining data collection details, click Next: Define Report

2. Full Editor displays the Data Collection tab

  1. Data Source: select the account you have created for IBM Cognos
  2. Data Collection Schedule: Specify the trigger that will be used to collect the data for your report
  3. Report: select a Cognos Report that should serve as a basis of a new internal Report
  4. Input Plug-in Command listing all the data you would like to fetch from Basecamp 2 (manually or using the Visual Editor)
  5. Once you are ready with you command, click Show Data

2.1. Visual Editor

Visual Editor

Visual Editor allows constructing commands without the need to learn the plugin syntax and avoiding typos/mistakes.

Just select those fields you would like to include into your report and define Override and Aggregation if necessary.

3. Plug-in command will be validated and Data Collected on Save from Visual Editor

  1. If the command is validated successfully, the Sample Results set and Report columns are going to br shown below.
  2. At the upper right corner of the screen click Update live Report


Add your comment

E-Mail me when someone replies to this comment