Hi All,

How can I go about identifying the cause of the below listed error message.

"Unable to drill through. The operation requested failed due to timeout"

We have AS sp3 installed, the cube size is around 5 million rows, drill
through rows have set at max 1000, but the clincher is that we are facing
this problem intermittently on the same cube.

It will display the data for some rows and pop the error messages for other
rows.

Thanks

a mystified person.

Depending on the OLAP client app that is used for drillthrough, the
timeout limit may be adjustable:

http://groups-beta.google.com/group/...rver.olap/msg/
d426adba0da70562

Newsgroups: microsoft.public.sqlserver.olap
From: lid... (AT) online (DOT) microsoft.com (linda deng[MS])
Date: Thu, 12 Sep 2002 06:26:42 GMT
Local: Wed, Sep 11 2002 11:26 pm
Subject: RE: Drillthrough and Timeout

Hi Joe,

The default timeout value is 30 seconds for the drillthrough in Analysis
Server 2000. If you use drillthrough in Analysis Manager, you cannot
re-set
the timeout value. However, if you access with your client application,
you
can re-set the value by setting the CommandTimeout property to a larger
value.

Sincerely,

Linda Deng
Microsoft Support Engineer

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!