Importing Cognos data

To import data from an IBM Cognos BI database, on the Data tab of the IBM Cognos BI dialog box ensure that Mode is set to Data.

Connection. Click the Edit button to display a dialog box where you can define the details of a new Cognos connection from which to import data or reports. If you are already logged in to a Cognos server through IBM® SPSS® Modeler, you can also edit the details of the current connection. See the topic Cognos connections for more information.

Location. When you have established the Cognos server connection, click the Edit button next to this field to display a list of available packages from which to import content. See the topic Cognos location selection for more information.

Content. Displays the name of the selected package, together with the namespaces associated with the package. Double-click a namespace to display the objects that you can import. The various object types are denoted by different icons. See the topic Cognos object icons for more information.

To choose an object to import, select the object and click the upper of the two right arrows to move the object into the Fields to import pane. Selecting a query subject imports all of its query items. Double-clicking a query subject expands it so that you can choose one or more of its individual query items. You can perform multiple selections with Ctrl-click (select individual items), Shift-click (select a block of items) and Ctrl-A (select all items).

To choose a filter to apply (if the package has filters defined), navigate to the filter in the Content pane, select the filter and click the lower of the two right arrows to move the filter into the Filters to apply pane. You can perform multiple selections with Ctrl-click (select individual filters) and Shift-click (select a block of filters).

Fields to import. Lists the database objects that you have chosen to import into IBM SPSS Modeler for processing. If you no longer require a particular object, select it and click the left arrow to return it to the Content pane. You can perform multiple selections in the same way as for Content.

Filters to apply. Lists the filters that you have chosen to apply to the data before it is imported. If you no longer require a particular filter, select it and click the left arrow to return it to the Content pane. You can perform multiple selections in the same way as for Content.

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. Click the button to display the parameters and optionally edit them. If the button is disabled, the report has no parameters defined.

Aggregate data before importing. Check this box if you want to import aggregated data rather than raw data.