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?
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.
