Re: MDX support in postgresql

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