I have Analysis Services 2000 SP3 loading cube from
Oracle 9.2.
There are a lot of dimensions and rows in the fact table
and query takes longer than 1 hr.
I tried to set MaxOLEDBTimeout parameter to 10 or more
hours (it was unchecked and 0 initially) - timeout still
occurs after 1 hr. I tried also changing
MaxOLEDBTimeoutefault parameter in registry to 10+ hrs -
same timeout.
Searching newsgroups and MS KB didn't help much - there
is some confusing info in KB 304213:

QUOTE
NOTE: There is no way to set the connect timeout for
Analysis Services and DSO to connect to the data source
such as
Microsoft SQL Server and Oracle. DSO always uses 15
seconds and Analysis Services uses the default
END QUOTE

The server has good hardware - quad 2 GHz Xeons and 4 GB
RAM - I tried bumping some of paramaters like number of
threads,
memory sizes etc w/o result.

Is there any way to make this working?