[Mondrian] issue with SQL query generation

Luc Boudreau lucboudreau at gmail.com
Mon Apr 7 10:34:46 EDT 2014

You'll need to give us a lot more information to be able to help you. Can
you share your mondrian schema, your MDX, your logs and ideally the data as

Without these informations, it's very unlikely that we can help you in any


On Mon, Apr 7, 2014 at 5:50 AM, Arvindkumar J <j.arvindkumar at gmail.com>wrote:

> Hi,
> I need a help regarding this issue -  when I select date dimension in
> FILTER with 2 dates selected and advertiser dimension in ROWS with one
> advertiser selected,
>  the read tuple query generated doesn't have the 2 selected dates in the
> predicate of the query. So, the readTuple query gets result for all the
> dates. This query takes lot of time to execute.
> But when i select only date in date dimension, the readtuple query has
> that date in the predicate and executes faster.
> Please let know if there is any known fix for this issue. I'm using
> mondrian 3.5.6.
> Thanks
> Arvind
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20140407/7a220cac/attachment-0001.html 

More information about the Mondrian mailing list