topic Re: Working with Cognos as a data source. in QlikView

Working with Cognos as a data source.

Mon, 25 Feb 2013 14:18:36 GMT

Hi all!

I'm about to start developing dashboards for the company that has implemented Cognos already. Obviously doing that within cognos is a solution I'd like to avoid, as the implementation is very weak and their reports are lacking a lot of functionalities. And now we encounter a problem - client will not allow us to access the data directly, so we'll have to use existing infrastructure. Is there a way to extract the data from it? As far as I know there's no too many cubes created but still need to get all of the data from there.

Been thiniking about TM1Qonnect from CarpeDatum (http://www.carpedatuminc.com/Products/TM1Qonnect.aspx) but not sure whether it'll work fine with cognos DW.

Any help appreciated.

PS.

I've found out that they're using very old software which is as follows (upgrade needed? 😞

DecisionStream	7.1
Framework Manager	8.1
Cognos Configuration	8.1

Re: Working with Cognos as a data source.

Wed, 27 Feb 2013 03:27:53 GMT

You are right, version 8.1 is an old one, not supported by IBM. The actual version of IBM Cognos is 10.2.

Qlikview can´t connect to cognos packages created with framework manager, then you need a direct access to the DW.

Why customer doesn´t allow you direct access to the database ? How do they think to provide it to qlikview ?

Best Regards,

Pablo Labbe

Qlikview Consultant

Re: Working with Cognos as a data source.

Wed, 27 Feb 2013 09:06:38 GMT

The problem is that their knowledge about Cognos/BI is.... very limited. They don't even know whether upgrade to cognos 10 is available for them at no cost or not (as we found out- as long as they pay maintenance fee, upgrade is free of charge). We'd rather stick to the solution with the QlikView, but working with Cognos 10 is also taken under consideration.

For the time being I am discussing direct access to ERP/CRM databases, as they don't even know whether they have a functional datawarehouse.

Re: Working with Cognos as a data source.

Wed, 27 Feb 2013 17:09:18 GMT

If customer have Qlikview and Cognos, consider to use Cognos when you need to deliver scheduled PDF or HTML reports by email or save it on a folder. All the other Business Users needs surely can be achieved with Qlikview.

Consider using the already created meta data model in framework manager to learn about the relationship between tables on the datasources and others business rules.

Kind Regards,

cid:656021617@23122010-1339

Pablo Labbe Ibaceta | QlikView Certified

Services Manager

Rua primeiro de março, 474 - 11º andar | 93010-210 | São Leopoldo - RS

( +55 (51) 3589-3009 +55 (51) 9261-3224

<mailto:pablo.labbe@visiongi.com.br> pablo.labbe@visiongi.com.br | 8 <http://www.visiongi.com.br/> www.visiongi.com.br

De: maciejewski

Enviada em: quarta-feira, 27 de fevereiro de 2013 06:07

Para: pablo.labbe

Assunto: - Re: Working with Cognos as a data source.

<http://community.qlik.com/index.jspa> QlikCommunity

Re: Working with Cognos as a data source.

created by maciejewski <http://community.qlik.com/people/maciejewski> in Connectivity and Data Sources - View the full discussion <http://community.qlik.com/message/315996#315996>

Re: Working with Cognos as a data source.

Thu, 28 Feb 2013 08:21:29 GMT

Thanks a lot.

So, if I understood you correctly, I need to learn the model, and then duplicate it in a QlickView script editor - is this what you mean?

Re: Working with Cognos as a data source.

Thu, 28 Feb 2013 12:42:28 GMT

Yes , you are correct !

De: maciejewski

Enviada em: quinta-feira, 28 de fevereiro de 2013 05:22

Para: pablo.labbe

Assunto: - Re: Working with Cognos as a data source.

<http://community.qlik.com/index.jspa> QlikCommunity

Re: Working with Cognos as a data source.

created by maciejewski <http://community.qlik.com/people/maciejewski> in Connectivity and Data Sources - View the full discussion <http://community.qlik.com/message/316491#316491>