Yellowfin 6.2 uses MDX sub-queries against Mondrian
7 April, 2013
In the process of evaluating Yellowfin 6.2, we have configured XMLA connections against cubes in the Mondrian 3.5 OLAP server we are using. When we add filters to the views, or attempt drill-down actions, the Mondrian server complains about MDX syntax errors. From reviewing the MDX queries, Yellowfin appears to employ sub-queries (i.e. uses SELECT clauses in the FROM section of the MDX query), which Mondrian does not support (see http://jira.pentaho.com/browse/MONDRIAN-980). We are under the impression this was not the case in Yellowfin 6.0. Is there a way we can instruct Yellowfin to use the MDX dialect supported by Mondrian (olap4j supports selection of the MDX dialect, if we are not mistaken).
Thanking you,
George Tsolis
Thanking you,
George Tsolis
Hi George,
Unfortunately we have not done extensive tests on Mondrian cubes and will need to in order to see if this is an issue with how the queries are being build for the report, or it's related to the driver itself.
We are thinking this is more likely an issue with how the queries are being built when drilling down, which means it could take some time to identify and resolve this in a YF update.
Are you using the March 6.2 release? I'm asking because we did make quite a few changes recently on olap connections.
Thanks,
David
Unfortunately we have not done extensive tests on Mondrian cubes and will need to in order to see if this is an issue with how the queries are being build for the report, or it's related to the driver itself.
We are thinking this is more likely an issue with how the queries are being built when drilling down, which means it could take some time to identify and resolve this in a YF update.
Are you using the March 6.2 release? I'm asking because we did make quite a few changes recently on olap connections.
Thanks,
David
Judging form the file name (yellowfin-20130221-full), we are using the February release. We can give the March release a try, in case this has been addressed.
Thanks,
George
Thanks,
George