Reading Cognos BI data

If you have access to a IBM® Cognos® Business Intelligence server, you can read IBM Cognos Business Intelligence data packages and list reports into IBM SPSS® Statistics.

To read IBM Cognos Business Intelligence data:

  1. From the menus choose:

    File > Read Cognos Data > Read Cognos BI Data

  2. Specify the URL for the IBM Cognos Business Intelligence server connection.
  3. Specify the location of the data package or report.
  4. Select the data fields or report that you want to read.

Optionally, you can:

  • Select filters for data packages.
  • Import aggregated data instead of raw data.
  • Specify parameter values.

Mode. Specifies the type of information you want to read: Data or Report. The only type of report that can be read is a list report.

Connection. The URL of the Cognos Business Intelligence server. Click the Edit button to define the details of a new Cognos connection from which to import data or reports. See the topic Cognos connections for more information.

Location. The location of the package or report that you want to read. Click the Edit button to display a list of available sources from which to import content. See the topic Cognos location for more information.

Content. For data, displays the available data packages and filters. For reports, display the available reports.

Fields to import. For data packages, select the fields you want to include and move them to this list.

Report to import. For reports, select the list report you want to import. The report must be a list report.

Filters to apply. For data packages, select the filters you want to apply and move them to this list.

Parameters. If this button is enabled, the selected object has parameters defined. You can use parameters to make adjustments (for example, perform a parameterized calculation) before importing the data. If parameters are defined but no default is provided, the button displays a warning triangle.

Aggregate data before performing import. For data packages, if aggregation is defined in the package, you can import the aggregated data instead of the raw data.