dbTalk Databases Forums  

Using SQL OLAP Services with Oracle

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Using SQL OLAP Services with Oracle in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
homio1
 
Posts: n/a

Default Using SQL OLAP Services with Oracle - 08-09-2003 , 09:46 PM






we currently stored our data in Oracle 8i. I was wondering
if the MS SQL Services can talk and create cubes in Oracle.

Reply With Quote
  #2  
Old   
Thuthuy Huynh
 
Posts: n/a

Default Re: Using SQL OLAP Services with Oracle - 08-10-2003 , 12:13 PM






Hi,

thanks for replying..I'm new to SQL OLAP services...currently, we are
using HOLOS from Seagate..we use Crystal Analysis Professional to build
worksheets on these cubes... we are experiencing lots of problems with
HOLOS..so I'm trying to look at another tool .....
you mentioned we can use another third vendor tool to view the cubes
once they are built..do u know if I can use Crystal Enterprise from
Crystal to pull data from these cubes? (I would be using Crystal
Analysis Professional)

thanks!


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

Reply With Quote
  #3  
Old   
Michael V
 
Posts: n/a

Default Re: Using SQL OLAP Services with Oracle - 08-10-2003 , 02:24 PM



Yes it can - but there are lots more to choose from - in a test between the
leading front end's (including Microsoft's own excel pivot + web pivot) it
didn't score that high - I think because it doesn' support all the features
in Analysis. You be the judge - here's some links to the test.

http://www.sqlmag.com/Articles/Index...rticleID=26399
http://www.sqlmag.com/Articles/Index...rticleID=26486

It's a great test - among other things you can download the questions (and
database) used so you get an idea of what they focus upon.

If this isn't enough you may need help from Nigel Pendse
(www.olapreport.com) - he's out there somewhere ...

\Michael V.

"Thuthuy Huynh" <tthuynh (AT) fcps (DOT) edu> wrote

Quote:
Hi,

thanks for replying..I'm new to SQL OLAP services...currently, we are
using HOLOS from Seagate..we use Crystal Analysis Professional to build
worksheets on these cubes... we are experiencing lots of problems with
HOLOS..so I'm trying to look at another tool .....
you mentioned we can use another third vendor tool to view the cubes
once they are built..do u know if I can use Crystal Enterprise from
Crystal to pull data from these cubes? (I would be using Crystal
Analysis Professional)

thanks!


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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.