topic Connecting to cubes from qlikview in QlikView

Connecting to cubes from qlikview

Fri, 06 Nov 2009 17:36:35 GMT

Hi,

Can we connect to OLAP cubes ( Essbase cubes/ Cognos cubes) from qlikview?

If so then how can we do it? If not then is there any way that the OLAP cubes that are already designed can be used by qlikview so that we can design user friendly, interactive UI

Connecting to cubes from qlikview

disqr_rm — Fri, 06 Nov 2009 22:44:34 GMT

You have couple of options.

SAP SQL Connector: Using this you would have load all the fact, SID (Dimensions), Text and Master data tables of your cube separately and link them back in QV to build your star schema at QV side. I know this sounds too much but trust be it's very easy and can be done in couple of hours once you get hang of it.

SAP OLAP Connector: Using this you would be able to connect to your queries and download data into QlikView. As alwasy, easy methods comes with limitations :-). This one also has some limitations like 1 Mi records support per fetch, no access to variables (i think), and so. But ofcourse there are workarounds you can develop or get some help to get developed for your environment.

DSO or ODS Connector: As it states, it will allow you to connect to ODS and download data.

My favorite is first one - reason: always works. If you can use #1 on top od DSO (or ODS) that would be perfect.

Best part is when you buy SAP COnnector from QLikTech, you get all of above mentioned together. Then you can play with any and see what fits your needs.

Hope I answered your question.

Connecting to cubes from qlikview

Mon, 09 Nov 2009 11:42:43 GMT

Thanks for you response.

Can I get a trial version of the SAP connector for download?

Connecting to cubes from qlikview

disqr_rm — Mon, 09 Nov 2009 11:54:32 GMT

It's not available to download. You would need to get it from QlikTech or your account partner.

By the way, it comes with some transports which would need to be imported into your SAP system. It's notjust download and start extracting data. Just an FYI.

Connecting to cubes from qlikview

Mon, 09 Nov 2009 12:05:39 GMT

Alright 🙂

Thanks for all the help 🙂

Re: Connecting to cubes from qlikview

konrad_mattheis — Tue, 21 Oct 2014 18:45:10 GMT

BIG news. Qlik has a Essbase Connector in the Download Portal.

So this should be solved.

bye

Konrad