TM1 Forum

Ok, you used to be able to do this in Excel 2003 but IBM have not upgraded the provider since then to support Excel 2007, 2010 and 2013. IBM support did suggest we regress back to Excel 2003 :D, bless them! I have raised an Enhancement Request with IBM to get this provider updated. So if anybody els...

Raised a PMR with IBM, and querying TM1 through Excel via the TM1 OLE DB MD provider is not possible. http://www-969.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=1403637468919&osPlatform=Windows Footnotes against Excel versions 2007, 201...

We are trying to use this to get data out of TM1 into Excel without the huge performance impact perspectives imposes, pretty much the way you can from other data sources connected using Excel. Again we are not managing to successfully connect. We have tried using the provider string "CAMNamespa...