Using the PowerPivot plugin for Excel, I noticed a MDX query for a table I need return the following after 60 seconds:
"XML for Analysis parser: The XML for Analysis request timed out before it was completed."
Is there any workaround to this? I tried changing the timeout values via Sql Server Management Studio for the analysis server but that doesn't seem to help. The MDX query runs fine on Sql Server Management Studio anyway, and several other queries that take
a while to retrieve data still work, suggesting it's caused by Excel.
Edited byyimingwuzereThursday, April 29, 2010 8:16 AMadded info