Thread: MDX support in postgresql

Hello,

I am wondering if you are considenring supporting MDX syntax in PostgreSQL?

Regards, Rikardo Tinauer
--
_______________________________________________
Rikardo Tinauer
EBA, Agencija za elektronsko poslovanje d.o.o.
Teslova ulica 30
SI-1000 Ljubljana
e-mail: rikardo.tinauer@eba.si
internet: www.eba.si
GSM: +386 031 382 379
TEL: +386 (0)1 477 66 01
______________________________________________

Rikardo Tinauer <rikardo.tinauer@eba.si> writes:
> I am wondering if you are considenring supporting MDX syntax in PostgreSQL?

Is there a standard for that, or is it just something
Microsoft-proprietary?  Stuff that is in the SQL2003
standard is generally on our "wish list" at some level
(no guarantees about how soon it might appear).  Copying
something that appears only in MSSQL sounds like a great
way to get in legal hot water, however.

            regards, tom lane

Tom Lane wrote:
> Rikardo Tinauer <rikardo.tinauer@eba.si> writes:
>
>>I am wondering if you are considenring supporting MDX syntax in PostgreSQL?
>
> Is there a standard for that, or is it just something
> Microsoft-proprietary?  Stuff that is in the SQL2003
> standard is generally on our "wish list" at some level
> (no guarantees about how soon it might appear).  Copying
> something that appears only in MSSQL sounds like a great
> way to get in legal hot water, however.
>

I haven't tried it myself, but see Mondrian for an open source
implementation of MDX:
   http://mondrian.sourceforge.net/
It should work with Postgres (as well as other JDBC datasources).

Microsoft is purportedly pushing MDX as a standard. Here's a discussion
of the MDX language:
   http://mondrian.sourceforge.net/mdx.html

HTH,

Joe