Execute query TimeOut in SSAS

Question

Hi

i designed DSV Inclued the fact tabel and dimensions and create relation

i replaced the fact tabel with named query , to condition on the table becouse the Recorde Count Of table Almost 4 Miliar record

i connect to TERADATA database from SSAS

When i create cube and trying to process , after 1 houre trying to execute th query retrive this error

 

Process failed timeout Expired

 

any one have any idea how to resolve this problem

Answer 1

Looks like it takes for Teradata in this case more than 1 hour to respond with query results.

Try changing ExternalCommandTimeout server configuration property to increase the timeout.

You can read more about it here:

http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/SSASProperties.doc

 

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.