Setting SQL Command Query Timeout
Use this key to set a different duration in seconds of the SQL command query before it times out, rather than the default 600. Follow these instructions:
-
Go to the Configuration page of Analysis Server web interface.
Navigating to the Configuration Page -
Locate the Root.Etl.SqlCommandTimeout key, click it, then set it to your desired value.
-
Click Save.
Setting Root.Etl.SqlCommandTimeout -
Click the Reset Session button at the bottom of the configuration table.