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:

Important: Cognos BI data will not fully import when a Cognos Analytics Administrator license is not present. You must either already have, or purchase, a Cognos Analytics Administrator license prior to importing Cognos BI data. Users who import Cognos BI data must have their role set as "System Administrator". For more information on license roles in Cognos Analytics, see How do you restrict users based on their License Roles in Cognos Analytics (versions 11.0.0 to 11.0.6).
  1. From the menus choose:

    File > Import Data > Cognos Business Intelligence

  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.