All paramteres for MSAS timeout from MS article KB 304213
set are appropriately. We are experiencing a timeout upon
a drill through operation on a cube with 15 million
records in the fact. The timeout occurs after 20 seconds.
Smaller cubes with 5 million records do not have this
problem.

The fact tables reside on SQL Server, with its remote
timeout set to 0 i.e. unlimited query time.

All suggestions would be appreciated.

Thanks,
Brett

Hi Bret,

The drillthrough timeout Property is exposed through OLE DB:

PropertySet: DBPROPSET_ROWSET

PropertyID : DBPROP_COMMANDTIMEOUT

Change the commandtimeout in the browser you actually use in business.

HTH,
Bas

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