SSAS 处理一段时间后再报错

错误提示：OLE DB error: OLE DB or ODBC error: Query timeout expired HYT00
错误提示：OLE DB 错误: OLE DB 或 ODBC 错误 : 超时已过期; HYT00。
解决：
AS的属性->常规->勾选显示高级(全部)属性->ExternalCommandTimeout把时间(毫秒为单位)加长

 

 

 

 

 

SQL Server 2005 Analysis Services has ExternalCommandTimeout setting that controls how long will Analysis Server wait for data source to return records. The default value is 3600 seconds (1h). To change it you need to go to Management Studio, connect to the server and open Properties and then click on Show Advanced Properties.