Re: Supporting MDX queries in 10gR2

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Tue, 12 Jan 2010 11:24:59 -0800 (PST)
Message-ID: <270923.84816.qm_at_web113207.mail.gq1.yahoo.com>

I think you may want to look at the OLAP option/functionality of Oracle.

http://www.dbazine.com/datawarehouse/dw-articles/rittman1

http://www.oracle.com/technology/products/bi/quicktour/html/olapdatabase.htm

 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it! Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles
Blog: http://robertgfreeman.blogspot.com Check out my new blog series on installing Oracle Database 11gR2 on Windows using VMWare!

---

From: Sandra Becker <sbecker6925_at_gmail.com> To: oracle-l <oracle-l_at_freelists.org> Sent: Tue, January 12, 2010 12:10:32 PM
Subject: Supporting MDX queries in 10gR2

Platform: IBM zSeries
OS: SLES10
Oracle: EE 10gR2  

Management is trying to determine whether the new database supporting a new product we're coding should be SQL Server or Oracle. At this point, the deciding factors are cost and supporting MDX queries. I must have the wrong keywords in my searches because I'm not finding anything that specifically allows MDX queries against an Oracle 10gR2 database. Oracle has not yet given a release date for 11g on the IBM zSeries so going to 11g isn't even an option. I've sent off a query to my Oracle account manager, but no response yet. Is there a product that allows for support of MDX queries in the 10g database?

--

Sandy
Transzap, Inc.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 12 2010 - 13:24:59 CST