COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: B.C. on 15 Jul 2019 04:03:51 PM

Title: Cognos Analytics 11.1.1 Dashboard Data Source Options
Post by: B.C. on 15 Jul 2019 04:03:51 PM
Having trouble finding this info anywhere. What are all the data source options for Dashboards in 11.1.1?.. specifically I need to find a way to use data currently within CQM and DQM packages?

Thanks in advance.
Title: Re: Cognos Analytics 11.1.1 Dashboard Data Source Options
Post by: MFGF on 16 Jul 2019 07:24:35 AM
Quote from: B.C. on 15 Jul 2019 04:03:51 PM
Having trouble finding this info anywhere. What are all the data source options for Dashboards in 11.1.1?.. specifically I need to find a way to use data currently within CQM and DQM packages?

Thanks in advance.

Hi,

The data source options you can use in a dashboard are:

- uploaded files
- data modules
- data server connections
- published packages
- saved data sets

For packages, you can certainly use DQM packages. You can also use CQM packages if the source is a PowerCube, or if the source is a relational database and you have also defined a JDBC connection for it (my observations are that it seems to convert it to DQM in memory on-the-fly). There are a few relational connection types with a dialog that allows both a client library connection and a JDBC connection to be defined together - eg SQL Server, Oracle, DB2.

Cheers!

MF.
Title: Re: Cognos Analytics 11.1.1 Dashboard Data Source Options
Post by: B.C. on 16 Jul 2019 11:20:34 AM
Thank you good sir, I must be missing the JDBC piece. Many thanks.