Analysis Services on top of an Oracle DB

[Joerg Narr]

Hi there,

can anyone tell me if Microsoft Analysis Services is as good on top of an
Oracle DB as it is on top of Microsoft SQL Server? I am especially
interested if it is possible to write-back data into Oracle - I couldn't get
it working and assume that it is not possible. I am also particularly
interested in any problems you ran in your mixed projects.

Please don't send me advice of the kind "use SQL Server relational" or
information on any *excellent* front end.

Thank you a lot.

Kind regards,

Joerg

[Joerg Narr]

I forgot... is the support of Oracle in AS 2005 better? Or am i forced to
use SQL Srvr relational with it?

"Joerg Narr" <joerg...@thedomain.below.de> schrieb im Newsbeitrag
news:42b958d9$0$16325$9b62...@news.freenet.de...

[ol...@gmsbv.nl]

Hi,

As far as I know there is now difference in writing back to for example
a ms access database or sql server database. This should be the same
for Oracle.

We have great experience with a DWH in Oracle and OLAP cubes in MS
Analysis Services 2000 + Panorama NovaView as webbased frontend for the
OLAP cubes.

Regards, Marco
www.gmsbv.nl

Joerg Narr schreef:

[Bj?rn Tingstadengen]

Based on my general experieces, you will see that the performace on
MSAS is considerably worse using an Oracle database as the direct
datasource. I believe the reason for this is the poorer performace
using the Oracle ODBC driver than the direct connection to the SQL
server database - often hosted at the same machine as MSAS. Also
internal network may inflict performance.

I did once try out using MSAS on top of Sybase. It worked nice but a
relatively small cube, 2,5 mill records of indata did calulate in
about 1 hour using Sybase. I later moved the source data to SQL server
and in this case the cube calculated in between 2,5-5 minutes.

RE
BT

ol...@gmsbv.nl wrote in message news:<1119478064.7...@g44g2000cwa.googlegroups.com>...