Connecting Queries Between Different Data Sources

This section lists the data sources between which you can and cannot connect queries.

IBM® Cognos® Analytics supports the following:

  • RDBMS to RDBMS joins
  • set operations of any two queries
  • master detail relationships between any two queries
  • drill from any query to any other query

You cannot create the following types of joins:

  • cube-to-cube (homogeneous)
  • cube-to-cube (heterogeneous)
  • cube-to-RDBMS
  • cube-to-SAP BW