Re: Supporting MDX queries in 10gR2
- From: Sandra Becker <sbecker6925@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Jan 2010 10:10:21 -0700
Dave, I asked my boss this morning where this was coming from. He didn't know either since it isn't on our product roadmap right now. Our development team tends to go off half-cocked at times and decide on a direction when it hasn't been approved by executive management. I asked for the requirements doc so I could review it to see if EssBase would fit the bill or not--no requirements doc has been done. So who knows why they were asking or even if they know what they're trying to accomplish. I did hear back from my tech account manager at Oracle and he said that EssBase should work on our platform. Waiting for a final confirmation now, although it doesn't appear the company is really ready to go down that road right now anyway. Thanks everyone for your responses. Sandy > > > On what basis has MDX been chosen as a pre-requisite? > > > > > > A friend worked on a data warehouse project where a consultant had > indicated that their product would generate all of the MDX queries required. > > > > Unfortunately MDX is a young standard, and some products are somewhat buggy > and will result in manual MDX query debugging being required. > > > > > > I have heard an opinion that the only MDX solutions that are mature are > from Microsoft and Cognos, although that is likely to be already out of > date. > > > > > > Do you know if the MDX requirement is driven by the selection of any > specific tool? > > > > > > Dave > > > > > > *David Roberts* > Senior Developer > > _________________________________________ > > *Logica* *- Releasing your potential* > > www.logica.com > > > > Logica UK Limited > Registered in England and Wales (registered number *947968*) > Registered office: 250 Brook Drive, Green Park, Reading RG2 6UA, United > Kingdom > > -----Original Message----- > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sandra Becker > *Sent:* 12 January 2010 19:11 > *To:* oracle-l > *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. > > Please help Logica to respect the environment by not printing this email / > Pour contribuer comme Logica au respect de l'environnement, merci de ne pas > imprimer ce mail / Bitte drucken Sie diese Nachricht nicht aus und helfen > Sie so Logica dabei, die Umwelt zu schützen. / Por favor ajude a Logica a > respeitar o ambiente não imprimindo este correio electrónico. This e-mail > and any attachment is for authorised use by the intended recipient(s) only. > It may contain proprietary material, confidential information and/or be > subject to legal privilege. It should not be copied, disclosed to, retained > or used by, any other party. If you are not an intended recipient then > please promptly delete this e-mail and any attachment and all copies and > inform the sender. Thank you. > -- Sandy Transzap, Inc.
- Supporting MDX queries in 10gR2
- From: Sandra Becker
- Supporting MDX queries in 10gR2