MDX support in postgresql

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