Hi ,

I am facing one problem in Excel Pivot Table. This is
happening while i try to drillthrough the data in excel
which is connected to a Database in Analysis manager. The
code is written in Excel as suggested in MSDN
(http://www.msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnexcl2k2/html/odc_xlextendolap.asp)

Most of the time i am getting the results in Excel....
some times i am getting a runtime error in Excel as given
below

"Runtime error -2147467259(80004005). The operation
requested failed due to Time out. "

In Analysis manager it's "Unable to drill through. The
operation requested failed due to Time out."

This is happening when i tried to drill through the lower
values for a member.

For Month Range Cnt
20 -30 5678
40-50 3455
60 and above 456

When i try to drill the 456, i am getting "time out"..all
the other will be ok...this is happening to all other
dimensions.....

Thanks in advance for any help regarding this...

Thanks & Regards
Sajith S

The default timeout for drill-through is 30 seconds, which may not be
enough in your case. I believe that you can increase the timeout for the
ADO Connection object, though such code is not included in the MSDN
sample code below.

In my case, someone on this NewsGroup sent me an Excel add-in for
drill-through, which uses a larger timeout value. But if you want to
modify the sample code, this excerpt from an earlier post may give you
some clue:

object?
e.g.

Dim cnxC as ADODB.Connection
...
cnxC.CommandTimeout = 90 'In seconds. Default is 30 seconds, I
believe.
...

HTH,
Paul.

- Deepak

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