Page 1 of 1
TM1 creating a drill through to a cube on another server
Posted: Thu Jan 09, 2014 4:07 pm
by stuartbarnes27
Has anyone been able to create a drill through from a cube on one TM1 server to a cube on another TM1 server?
I was hoping to use the ODBO data source but it is disabled for drill processes.
I also thought of trying to use the TM1 OLE DB connector to create an ODBC data source, but since TM1 is not a relational data source you cannot use ODBC.
Any other ideas?
Re: TM1 creating a drill through to a cube on another server
Posted: Fri Jan 10, 2014 3:39 am
by yyi
Fresh out of ideas here
If it's for a challenge, then It'll probably take writing a new java interface + drill function.
A faster realistic way could be as you would have guessed, is having a static clone cube
that updates itself through a chore.
Re: TM1 creating a drill through to a cube on another server
Posted: Fri Jan 10, 2014 4:45 pm
by PlanningDev
Drilling to cube views produces a different result than when drilling to ODBO, ODBC, Flat File, etc. Cube Views will drill to the Cube Viewer, while the other sources just show up as an ugly version of notepad data on the web.
If you are ok with the ugly view then a long work around could be to call TM1RunTI.exe which calls a process on the other server to dump data to file. You would need to parametize that TI and pass your params in so that you could dynamically create the view for export. Then your drill process would would read in the data from that file.
In reality you would be better off following yyi's idea and just replicate the cube you want to drill to into your current server and to chore that replication.