Cognos Analytics 11.1.1 Dashboard Data Source Options

[B.C.]

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.

[MFGF]

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.

[B.C.]

Thank you good sir, I must be missing the JDBC piece. Many thanks.