How can I prevent client submitting MDX queries to the Analysis Server 2005 that run too long
Q: How can I prevent client submitting queries to the Analysis Server that run too long?
A: Sometimes clients submit queries to SSAS server that uses a lot of resources. One of the things you can do is to add timeout parameter to the connection string and this way limit time query is allowed to run. After client receives timeout message, he/she could adjust query selections and re-submit smaller query. Timeout parameter is specified in seconds.
This query will timeout after 120 seconds.