We have created a linked server to a SSAS 2008 Cube on our SQL 2005 server , and tested this..Works fine. Now we are trying to run a MDX query through OPEN QUERY from our server. The query runs for about 10 minutes and times out. So we set the
Remote Query timeout to "0" on our server and ran the OPEN QUERY. But still it times out after 10 minutes or so.
Any suggestion to solve this issue?
Thanks in Advance!
View Complete Post