IBM Cognos BI Source Node

The IBM Cognos BI source node enables you to bring Cognos BI database data or single list reports into your data mining session. In this way, you can combine the business intelligence features of Cognos with the predictive analytics capabilities of IBM® SPSS® Modeler. You can import relational, dimensionally-modeled relational (DMR) and OLAP data.

From a Cognos server connection, you first select a location from which to import the data or reports. A location contains a Cognos model and all of the folders, queries, reports, views, shortcuts, URLs, and job definitions associated with that model. A Cognos model defines business rules, data descriptions, data relationships, business dimensions and hierarchies, and other administrative tasks.

If you are importing data, you then select the objects that you want to import from the selected package. Objects that you can import include query subjects (which represent database tables) or individual query items (which represent table columns). See the topic Cognos object icons for more information.

If the package has filters defined, you can import one or more of these. If a filter that you import is associated with imported data, that filter is applied before the data is imported. Note: The data to be imported must be in UTF-8 format.

If you are importing a report, you select a package, or a folder within a package, containing one or more reports. You then select the individual report you want to import. Note: Only single list reports can be imported; multiple lists are not supported.

If parameters have been defined, either for a data object or a report, you can specify values for these parameters before importing the object or report.