I was wondering if there is a in-memory OLAP server which can handle MDX. I found the Wikipedia article. But it says nothing about in-memory functionality... The only one I know of them is ...

I want to implement an application that provides support for MDX queries. For this purpose I would like to use one of libraries from pentaho mondrian (an open source OLTP server with the MDX interf...

I need an MDX query for Mondrian filtered by date, where one or both of the boundry dates may not exist. I'm using the query below that works as long as both 2013-01-01 and 2013-01-08 dimensions ex...

Is it possible to browse a Mondrian Cube through Microsoft Excel? like it is done with Microsoft SSAS? If not is there a possibility to use Sharepoint as a front end to browse a Mondrian cube?

I have been struggling to get aggregation tables to work. Here is what my fact table looks like: employment_date_id dimension1_id dimension2_id dimension3_id dimension4 dimension5 measure1 measure...

I am having trouble finding how to create a simple web-app to analyse its data on OLAP cubes with Mondrian. I have a small database that consists only of one fact table and 2 dimension tables. I...

While reading manual of Mondrian I found that it has not so much types including Integer and Numeric - what's difference between this types? And how can I use timestamp level type?

Reality description: We do have a list of projects. In every project there is a lot of accounts. You can do a lot of actions on every account. I do have the following dimensions and fact table defi...

Has anyone tried to access an OLAP server offering a XMLA API (such as Mondrian) from R? I'd love to run MDX queries from R against Mondrian and retrieve result sets.

I am trying to install Mondrian on my Mac OS X. I am facing the below error at step 12 of this guide Command is as below :- java -cp “/usr/local/tomcat/webapps/mondrian/WEB-INF/lib/mondrian.jar: ...

My database team has set up a database Cube using MySQL database. I need to connect to this Cube from PHP and get the data using MDX queries. I can't find how to do that. Could someone please help...

Summary: Most of the examples I've seen of MDX joins have involved joining relatively small sets, say with tens or hundreds of items each. But I find myself also wanting to try joining (in particul...

I'm using CURL to send a SOAP request to Mondrian. This is the PHP code where CURL is being used: $poststring = '<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" S...

Are there any performance advantages in using a ROLAP server such as Mondrian on top of a MySQL database, as opposed to simply querying the MySQL database? I am asking this in the context in which...