OLAP in Vertica: MDX vs. SQL OLAP extensions
Moderator: NorbertKrupa
OLAP in Vertica: MDX vs. SQL OLAP extensions
From what I read on the website it seems that Vertica doesn't support MDX; is it part of the roadmap? Is SQL+OLAP Vertica's recommendation to deploy OLAP client apps? I believe I read Vertica supports SQL:2008. Thanks.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: OLAP in Vertica: MDX vs. SQL OLAP extensions
Vertica does not support MDX queries, however, it can be integrated with Mondrian (http://mondrian.pentaho.com/) or Microsoft SQL Server Analysis Services (SSAS) which do support MDX.
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: OLAP in Vertica: MDX vs. SQL OLAP extensions
FYI - I just heard that MDX support is in the Vertica pipeline (as a feature request); but there is no set release date.
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: OLAP in Vertica: MDX vs. SQL OLAP extensions
Thanks. One of the advantages of Mondrian is that it caches aggregates to improve query performance. If I use SQL+OLAP extensions to query in Vertica, does it have a similar feature? thanks