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
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:
Edward.-- This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?