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