topic TM1 (MDX) integration with Qlikview in QlikView

TM1 (MDX) integration with Qlikview

Wed, 27 Apr 2011 20:47:27 GMT

Has anybody successfully sucked in IBM TM1 data? I was able to install the TM1 OLE DB driver that comes with the client installer, create and successfully connect to the data source in Qlikview, but now here I am wondering what to do next. As we know TM1 stores data in OLAP cubes so MDX must be used to extract. Looking at what others have done on the forum I have seen people using openrowset to connect to analysis services.

Has anybody used openrowset to connect to a TM1 data source? Or any other way to extract data from TM1?

Anything would be appreciated. Thanks!

TM1 (MDX) integration with Qlikview

disqr_rm — Thu, 28 Apr 2011 01:02:30 GMT

Take a look here:

http://community.qlik.com/forums/t/30459.aspx

TM1 (MDX) integration with Qlikview

Thu, 28 Apr 2011 02:00:26 GMT

Rakesh,

Thanks for replying. I actually saw this post (your post) and it helped me get to the point where I am. Again I've installed the OLE DB driver for TM1 and able to successfully connect using the desktop. My problem is MDX. How do I extract data from the TM1 cubes? it's not like SQL where I can just say select * from cube name or something like that. I've seen people give openrowset examples but not against TM1.

Thanks!

TM1 (MDX) integration with Qlikview

disqr_rm — Thu, 28 Apr 2011 04:02:00 GMT

Hi DB,

This helped me last time when I was struggling with same: Link

Hope this helps you too. Good luck.

Rakesh

Re: TM1 (MDX) integration with Qlikview

Wed, 09 May 2012 13:06:54 GMT

I have the same problem, connected successfully. But how do i extract the data from TM1 to qlikview?