How to avoid Long running MDX Requests
I wanted to write a small post about ‘Timeout’, which really helped me practically to manage long running MDX requests.
Example of connection string with Timeout
Provider=MSOLAP.3; Data Source= MySSASServerName; Initial Catalog= MySSASDBName; User ID= windowsusername; Password= windowsuserpwd;Timeout=120;
In the above example, requested MDX would be allowed to run in 2 minutes. After 2 minutes request will be cancelled.