IBM Cognos Executive Viewer connects to TM1 via the OLE-DB provider:
Therefore, it should be possible for Tableau to provide a generic OLE-DB data source connection dialog which could be used to point to the TM1 OLE-DB provider (this dialog could then also be used to point to the SAS OLE-DB provider). It would essentially be the same connection as is used to connect to Microsoft Analysis Services today.
Current workarounds include using the TM1 Excel add-in to export the required TM1 data, or create TM1 TI (Turbo-Integrator) ETL scripts to export the TM1 data. There is a Microsoft technology partner in Australia who claim to have written a utility to 'migrate' a TM1 cube into Microsoft Analysis Services, but I'm not sure whether this has been 'packed up' as a product offering.
not sure if your requirement is still relevant given the time lapse, but CarpeDatum has a product called TM1Connect. It simplifies the connectivity issues caused by multidimensional olap tools dramatically.
You can check it out here:
Interesting. I would like feedback from those who've used this with Tableau Desktop and especially Server (I honestly don't care about it's use with other, non-Tableau products).
our mob at Tridant has tested it extensively and are in the process of implementing. Fundamentally TM1Connect has two ways of getting data from IBM Cognos TM1.
Batch is simply executing Turbo Integrator (TI) processes to push the data into TM1Connect.
On-demand constructs a view which is used as the source.
In each of these TM1Connect leverages TM1's caching capability to ensure that there is no compromise on speed. I need to caveat that statement by saying that TM1Connect will not provide a solution for bad cube design. If your cubes are slow, you cannot expect TM1Connect to be responsive.
Additional features like caching of dimensions and attributes from IBM Cognos TM1 and caching of Tableau SQL statements all add to the performance of this tool.
If you have any specific questions, feel free to ask.
This is a very exciting tool for us and a big kudos goes out to the CarpeDatum team.
I can not wait for a bi-directional connector
is there any update regards this link??