TI to access cubes from another serverthrough ODBO connection

[Richa]

Can we create a TI process to facilitate access to the data from another cube in a different server without having the second server being manually started? OR
Is there anyway to physically login to the second server.

[dusherwo]

You can issue MDX queries from one server to another, but when we last tried it (admittedly many versions ago) the MDX was pretty quirky and the implementation didn't scale to production volumes. Maybe now they've been forced to tighten it up with 9.5.2 it might be better.

[Richa]

Hi, i tried some MDX queries but didn't acquire satisfactory results. Would you mind sharing the MDX query?
Thanks for your inputs.