Report Portal

How do you increase timeout for queries executed during Analysis Services cube processing

Q: How do you increase timeout for queries that are executed during MOLAP cube processing?

A: In SQL Server Management Studio connect to Analysis Services server, then right mouse click on the server and choose properties. You have to select "Show Advanced (All) Properties" and change property "ExternalCommandTimeout". Default value is 3600 seconds.

Tags: faq, management

 

2007-2015 VidasSoft Systems Inc.