Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: Richa on 15 Mar 2011 05:56:43 AM

Title: TI to access cubes from another serverthrough ODBO connection
Post by: Richa on 15 Mar 2011 05:56:43 AM
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.
Title: Re: TI to access cubes from another serverthrough ODBO connection
Post by: dusherwo on 16 Mar 2011 06:10:20 PM
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.
Title: Re: TI to access cubes from another serverthrough ODBO connection
Post by: Richa on 27 Mar 2011 10:39:10 PM
Hi, i tried some MDX queries but didn't acquire satisfactory results. Would you mind sharing the MDX query?
Thanks for your inputs.
Text only | Text with Images